Prompt for filename while importing files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Ray - 24 Sep 2007 08:04 GMT

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.

Signature

Best regards
Ray Ray

Reply to this Message

Pieter Wijnen - 24 Sep 2007 10:16 GMT

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

> Dear sir
>
[quoted text clipped - 5 lines]
> 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.

Reply to this Message