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?

 

[GBA]

because the task is appending an mssql table; it is a task for mssql. it is
not an MS Access task

this is not to say that Access can not append to an mssql table; just that
in terms of management/ownership/security it should be the mssql owner that
controls what/how/when data is written to their table - in my humble
opinion...

having said that; you must link to the mssql table such that it is just
another table object; then create an append query to update it....