Importing multiple .csv files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel Gerber - 30 Mar 2005 17:14 GMT

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

Reply to this Message

John Nurick - 31 Mar 2005 06:58 GMT

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.

>Hi
>
[quoted text clipped - 7 lines]
>Access 2003, Win XP pro
>Thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message