Transfer data from any mdb file to sql server?

R

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?
 
Top