Hi
I have around 700 text files. Every files contains 3 colums, this columns are double type numbers.
How can I import these files at the same time?
Hi
I have around 700 text files. Every files contains 3 colums, this columns are double type numbers.
How can I import these files at the same time?
Since you have Excel 2016...
If you have all the text files in same folder. You can use binary combine method.
Have a read of link for details. If you need more specific help. I'd recommend uploading sample text file(s) and expected result.
https://exceleratorbi.com.au/combine...s-power-query/
To upload, use "Go Advanced" button and follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks