Import an ODBC file from code

[McLean J]

I have been given the DSN, username and password of a SQL database and need to write code to
1. import the data into a new table
2. append the data into an existing pre-defined table

These would be two separate options.

Where is a good resource for this feature?

mcj

 

[Rodrigo]

You could just do a link table to the sql server and then either create
MakeTable query or an Append Query.

That would be the easy way. Or you could get complicated and open recordsets
to the sql server database, or a passtru query, etc, etc. It's all on the
help.