Importing multiple .csv files

[Daniel Gerber via AccessMonster.com]

Hi

Please Help this newbie! I need to populate Access table (or SQL table)
with info from several .csv files that gets dumped into a c:\maildump
directory. Thereafter the .csv files to be archived to c:\updated
directory. The names of the .csv files differs daily eg 05032901.csv,
05032902.csv, 05032903.csv for the three files that arrived on the 29'th.
Any nice VBA ? procedure to identify, populate and move to archive?

Access 2003, Win XP pro
Thanks

 

[John Nurick]

Hi Daniel,

If you search http://groups.google.com for
fallon "import all files in a folder"
you'll find what you need to get started.