Prompt for filename while importing files

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Csv import: direct link vs temp table dump 2
Add .csv File Name When Importing Multiple Files Into a Table 0
Import multiple csv and add filename in additional field 4
Access Importing csv daily files into access 2007 1
CSV Import with duplicate field names 3
Can not import .csv file 1
help creating a button to import .csv file... and more.. 1
Invalid Argument Error when importing .csv to Linked Table 1

Back
Top