Import multiple CSV files

[PR]

I need to import about 100 .csv files... I have imported 1 file and created a
spec file... does any one know a way of importing more than 1 file at a
time...

Regards
PR

 

[Roger Carlson]

Check out Ken Snell's website:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpFolderFiles. I think
the process can be adapted to .CSV files using the TransferText method
instead of TransferSpreadsheet.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[first1downhill]

I use a DOS command for such things.

Get to the DOS prompt and then type in the path to the folder containing the
100 csv files. Copy *.csv to Master.txt and then I renamge Master.txt to
Master.csv (otherwise the command tries to copy Master.csv into itself). Now
you have just one file, Master.csv, to import.