Read multiple CSV files and append into one sheet

[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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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