Import ODBC table using VBA code?

[Jason-W]

Hi,

I found a problem with my connection string. I found a
part in the help file that shows where to get a correct
one from under "TransferDatabase Action". If anyone else
needs to know, here's the info from the help file:
Connectivity (ODBC) connection string. To see an example
of a connection string, link an external table to Access
by pointing to Get External Data on the File menu and
clicking Link Tables. Open the table in Design view and
view the table properties. The text in the Description
property setting is the connection string for this table.<<

Regards,
--Jason