importing data with ODBC Data

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

Guest

I use the following to import data to Access:

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=CamraTS;UID=Admin;PWD=;LANGUAGE=us_english;" _
& "DATABASE=CamraTS", acTable, "admin.security", "dboCamraSecurity"

Is there a way to adjust this command or another command to import the
results of a SQL query rather than import all the records in a table.

Basically, I need to import another table that is 1MM+ records and would
like to
apply a WHERE clause before the import.

I'm using Access 2003

thanks
Rich
 
You should be able to link to the table, create a query that only returns
the data you want and convert that query into a MakeTable query.

Alternatively, you might be able to create a pass-through query, thus
combining steps 1 and 2 above.
 
Back
Top