Copy multiple CSV files into one access table

[laurennickell]

I am trying to upload hundreds of CSV files from one folder into one access table without manually having to enter each file. I have never written a program to do this, could anyone help me and tell me the steps in order to run it

[andy49]

http://www.accessmvp.com/KDSnell/EXCEL_Import.htm


Sent from my iPhone using Tapatalk

[Micron]

maybe something like this
http://stackoverflow.com/questions/3...ple-text-files
You didn't say they were Excel csv files - they might just be delimited text...

[laurennickell]

I am new to using programming within Access, do you know where I could see a tutorial on how to insert and run the program correctly

[orange]

Here's a tutorial that may help.

Good luck.

[ssanfu]

You might also see Ken Snell's site:

Ken's ACCESS Examples and Information for Working With EXCEL Workbook Files
http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm