link tables using vba

[dumbledown]

Hi,

I have an n number of csv files in a folder that I want to link automatically to an access 2007 database. They are all named in the format file_n.csv, and the value n will change from use to use.

So we have files:
c:\folder\file_1.csv
c:\folder\file_2.csv
c:\folder\file_3.csv
-
-
c:\folder\file_n.csv

Does anyone know what code I need to link all of these files as tables?


Many thanks
Hugh

[June7]

Google: VBA link csv

Here is one
http://social.msdn.microsoft.com/For...7-0233661ec221

You would need loop code that dynamically references the csv file name. Need to know how many files in the folder. You can have the number of files as input parameter or find code that would determine how many files are in the source folder.

[dumbledown]

Thanks June 7,
That looks just the thing.
I already have code that works out the value n, so do you know how the loop would work?
I'm sure I can work it out, but I'm a beginner at VBA.
Thanks again!!

[dumbledown]

Got loop all running now.
Thanks again for the code, it worked perfectly!