Import (ODBC) using query as criteria

[deb]

My database must import data to a table via ODBC. However there is over 1900 records in Louts Notes. At present time I am importing all 1900 records. yucky.

Is it possible to use a query in my Access2000 database to import, only the specific records(only 35) in this query, from Lotus Notes via OBDC?

If so, Please, tell me how... ray:


Thanks in advance,

 

[Dugantrain]

Sure, use a Pass-Through Query. You'll have to write the SQL yourself, but doing so will allow you to filter for only the records that you want.