importing data with ODBC Data

[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

 

[Douglas J. Steele]

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.

 

[Guest]

thanks,

does anyone have an example of the make table query? i'm a novice...

thanks