Read multiple CSV files and append into one sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a request to read in Multiple CSV fieles from one location and create
one EXCel S/Sheet with one work shett with to holder all the CSV files
together in this one File and one Worksheet.

Does anybody have a quick solution to do this, if you have the code that
would be perfect

Thank you
 
Link to each csv as if it were a table.
Use an append query to copy the data into the table.
Drop the Link
Do it again.
 
Here's one way:

1) assuming all the CSV files are in one folder, use the Windows COPY
command to concatenate them:
COPY "D:\Folder\subfolder\*.csv" "D:\Folder\subfolder\XXX.csv"

2) launch Excel, open XXX.csv and save it as a workbook.


John Nurick
Microsoft Access MVP
 
Thnak you John, that Coy command from the Command Prompt solved the whole
thing for me, I don't need a VB utility at all now

Thank you for that, very impressive
 
Back
Top