Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you point a way to join multiple .CSV(s) files into one?

Hi Experts

Could you point a way to join multiple .CSV(s) files into one?

I had tried  to use TXTCollector but it doesn't work fine everytime.

Sometimes this error occurs:
[Error] - File could not be written...

Open in new window


Amazingly the files were generated the same way.

Thanks in advance!
Avatar of Daniel Pineault
Daniel Pineault

What language are you working in?
ASKER CERTIFIED SOLUTION
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Eduardo

If you are using Excel then, depending on which version you have, you could use Power Query to 'join' the CSV files into one file.
If you use Excel 2o16 you can use Data tab, New Query button (or Get Data button, depends on your exact version), From File, From Folder.
Avatar of Eduardo Fuerte

ASKER

Hi

The reason I had to merge all the .CSV(s) files was to furnish it to another dev team data to be exported to MSSQLServer.
I decided to import every .CSV directly to MSSQLServer by using dbForge for MSSQLServer that gives a very robust importation tool.
I consider your solutions valid paths.
Thanks for help!
I am not an Expert at all.  Answer could be wrong.
I use software Delimit. It is free to try for a month. I have joined up to 100 GB.
I see it now. Powerful!