Import an ODBC file from code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top