Importing a Lotus Notes database via ODBC code

[cstaab]

I am trying to import a lotus notes table into an access table. I can do this correctly by hand by selecting File-Get External Data - Import. However I cannot seem to obtain the correct code to do this process automatically.

Typically I would do it by hand each time, however with the large amount of records that I am working with, this is a long process. Each day I want to bring back the records with the "Data" field >= yesterdays date.

Thanks to anyone who can help!

 

[Pat Hartman]

You would use the TransferDatabase Method or Action to do this in code.