G
Guest
I'd like to get the correct syntax for importing a table from an ODBC link.
I pulled the following syntax for a different type of file from this board
but don't know how to modify it for ODBC:
DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\temp", acTable, "member",
"member"
Information from linking the file shows:
DSN=Dev_pes_reporting;DATABASE=pes_reporting . The table name is dboAcc.
I'm trying to automate the import because directly querying the ODBC table
is very slow for some reason, it's much faster to import the table (which I'm
currently doing manually) and then query the copy.
I pulled the following syntax for a different type of file from this board
but don't know how to modify it for ODBC:
DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\temp", acTable, "member",
"member"
Information from linking the file shows:
DSN=Dev_pes_reporting;DATABASE=pes_reporting . The table name is dboAcc.
I'm trying to automate the import because directly querying the ODBC table
is very slow for some reason, it's much faster to import the table (which I'm
currently doing manually) and then query the copy.