Prompt for filename while importing files

[Guest]

Dear sir

I receive a CSV file from my bank everyday, and I need to import it into a
table (names "TEMP TABLE", for example) in my Access 2000 database.

How should I write a macro/module so that Access firstly asks me to specify
a CSV file, then skips the import wizard and imports directly to "TEMP
TABLE". Pls let me know if you need further information. Thank you.

 

[Pieter Wijnen]

OpenFileDialog Function to be found at http://www.mvps.org/Access in the API
section
For the rest : make a import spec using the import wizard
Use DoCmd.TransferText to perform the actual import

HTH

Pieter