Data import with 'variable file location'

#1

Hi NG

Every month end, I need to import data (*.txt and *.csv files) into some
tables. These files are on the same server, in the same folder. BUT the
folder name (=file location) changes every month.

How can I set the path of the file location, so I can import these files via
a macro?

Thank you for your help!

Cheers, Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data import with 'variable file location'

comp.database.ms-access comp.database.ms-access

Data import with 'variable file location' - 07-03-2003 , 11:11 AM