Importing multiple Access databases  
Author Message
chvid





PostPosted: Wed Jul 21 16:16:16 CDT 2004 Top

SQL Server >> Importing multiple Access databases

Hi,
I have 30 remote sites that each day send an access
database of sales figures for that day, how can I automate
the process of importing these into an SQL database. I run
SQL server 2000.

As simple a solution as possible please as I am new to SQL
server.

Thanks Dave

SQL Server53  
 
 
Keith





PostPosted: Wed Jul 21 16:16:16 CDT 2004 Top

SQL Server >> Importing multiple Access databases Assuming the access db's always have the same names, and are located in the
same way, you should be able to simply import the data into your SQL
database, by right clicking the database, selecting import, and then going
through the wizard which is reasonably self explanatory.

At the end of the wizard you will be asked if you want to run the import
now, save it, or schedule it. If you choose the schedule option you can then
select a time for that data to be imported, and how often it should be done,
and from there it should go through without a hitch. To test it, go to
Management, SQL Server Agent, Jobs, and you should see your DTS job in the
right hand side. Right click on it and tell it to start, and it will go
through and perform the import. Once finished you can see the status of the
job, and if necessary view the job history and details of what happened if
it fails for some reason.

Hope that helps
Keith



> Hi,
> I have 30 remote sites that each day send an access
> database of sales figures for that day, how can I automate
> the process of importing these into an SQL database. I run
> SQL server 2000.
>
> As simple a solution as possible please as I am new to SQL
> server.
>
> Thanks Dave