Transfer data from any mdb file to sql server?

[robeito]

Hello everybody

I must develop an application to transfer data from mdb file to an sql
server database.

The input mdb file is selectable by the user (all the mdbs have identical
tables)

The target database is always the same

The easiest way for me would be to have links in my application pointing to
the selected mdb tables , and links pointing to the sql tables. And then do
the transfer

Any idea about this?
Shall I try an adp project?

 

[Armen Stein]

Hello everybody

I must develop an application to transfer data from mdb file to an sql
server database.

The input mdb file is selectable by the user (all the mdbs have identical
tables)

The target database is always the same

The easiest way for me would be to have links in my application pointing to
the selected mdb tables , and links pointing to the sql tables. And then do
the transfer

Any idea about this?
Shall I try an adp project?

You can use a regular MDB front-end application. An ADP doesn't
natively link to Access tables.

Link your SQL Server tables.
Also link your Access tables from one of the Access databases.

Use Append queries to transfer data from the Access tables to the SQL
Server tables. As long as you have a fast network connection and you
aren't talking about millions of records it should run quickly enough.

If you want an easy way to switch the links for the Access back-end
database, you can use our free J Street Access Relinker at:
http://www.jstreettech.com/downloads

Armen Stein
Microsoft Access MVP
www.JStreetTech.com