Automatically Combine a Folder of CSV Files.

There are number of ways to do it.

But you'll need to provide sample csv and how it should be combined.

To upload file, use "Go Advanced" button and follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.

Several methods.
1. Get PowerQuery add-in from MS. And use binary combine.
2. Use VBA. Using Dir function to iterate through files, open and copy range.
3. Use VBA. Using ADODB and SQL query to combine CSV. This is bit complex if you are not used to it, and will require schema.ini file to be created.
etc.

If using PowerQuery method follow instruction in the link.
https://www.myonlinetraininghub.com/...-from-a-folder

For PQ Add-in download follow link below.
https://www.microsoft.com/en-ca/down....aspx?id=39379

If using VBA method. See below for sample code using variation of method 2 in post #2.
This assumes that you have all csv to be imported in same folder. Change fPath as needed.
See sample attached.

Please Login or Register  to view this content.

Note: Depending on your process, this requires additional coding. My recommendation is to move files to another folder, once imported.

Morning CK76,

Many thanks, your VBA option works perfectly.

I added a little so on open it deletes the data and merges capturing any new data.

Just a small one is there a way to slightly adjust the VBA a little to get it rename a few columns headers?

i didn't notice at first but some of the header the machine generates are confusing.

MANY MANY Thanks for your help with this though

Dale J

Please Login or Register  to view this content.

Dale

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Just a small one is there a way to slightly adjust the VBA a little to get it rename a few columns headers?

Actually, code isn't doing anything with headers. Since headers will be constant. I skip them in import process.
It's just manual copy and paste from source csv file. You can change it to anything you want, and it won't impact the code.