importing a number of CSV text files into 1 table

[swk003]

Is there a way of importing a number of text files (approx 100 files)comprising CSV data into 1 Access TABLE in one single go or command?

thanks

Simon

 

[Hap007]

Sure Can.

If all the CSV files are the same, fields, names, etc..

Then, take one of the files, use it as a template and save the template.

Now, using VBA code, you can use the template to loop through all the files and import each one.

Hope this helps.

Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers