Forum Discussion
Notepad to Excel - Data Transfer
Hi guys,
I need to import a very large amount of data from an Microsoft Notepad into an Excel file but the data set is too large for one Excel file (stops at about 1.4m rows).
It doesn't specify how much of the Notepad data did not import to the Excel file and I was wondering if you knew how to move the rest into a second (or third) Excel file?
I have done this under the data tab and 'import from text' but as I mentioned I am unable to import the remainder after the initial data transfer.
All suggestions welcome!
Thanks,
Alex
You can use Power Query to import the data as it seems you did, but at the end, instead of loading to a table, select "create connection only" and "Add to the data model". This way the data will not be visible in the worksheet but is available in the memory for data analysis using pivot tables.
Here is a tutorial: https://www.youtube.com/watch?v=5u7bpysO3FQ
6 Replies
You can use Power Query to import the data as it seems you did, but at the end, instead of loading to a table, select "create connection only" and "Add to the data model". This way the data will not be visible in the worksheet but is available in the memory for data analysis using pivot tables.
Here is a tutorial: https://www.youtube.com/watch?v=5u7bpysO3FQ
- Thanks a mill - I really appreciate it!
You are very welcome! 🙂
Please give it a try and if it solves your problem, please remember to mark my answer as a solution to your question. Thank you.
