Eduardo Fuerte
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:
Amazingly the files were generated the same way.
Thanks in advance!
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...
Amazingly the files were generated the same way.
Thanks in advance!
What language are you working in?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 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.
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.
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.
ASKER
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 use software Delimit. It is free to try for a month. I have joined up to 100 GB.
ASKER
I see it now. Powerful!