-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Loading 14m records into Excel via .txt file
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,407
The big question is: what are you going to do with all those records?
If you just want a backup, then keep the text file.
If you want to extract some information and create a report, then you could write an Excel macro to read the text file line by line, pull the information you want from each line, then put a summary in the spreadsheet at the end.
If you want to keep the data and have the ability to query it and create ad hoc reports, then you need Access or some other database. Excel can work as a database for relatively small amounts of data, but 14M is way above that limit. Yes, there is a learning curve to using Access, but if that's the right tool for the job, it's worth the effort.
If you just want a backup, then keep the text file.
If you want to extract some information and create a report, then you could write an Excel macro to read the text file line by line, pull the information you want from each line, then put a summary in the spreadsheet at the end.
If you want to keep the data and have the ability to query it and create ad hoc reports, then you need Access or some other database. Excel can work as a database for relatively small amounts of data, but 14M is way above that limit. Yes, there is a learning curve to using Access, but if that's the right tool for the job, it's worth the effort.
Upvote
0
Similar threads
- Question
- Question
