-
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.
Import large text files into Excel
- Thread starter sam88
- Start date
Damon Ostrander
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 4,239
Hi Sam,
Yes, a macro can do this. But exactly how to code this macro depends on how you want the 250000 lines imported. For example, do you want the file to be split among several worksheets (four would be required)? If so, do you want it split evenly, or each sheet (except the last) filled all the way to 65536 rows?
If your 250000 lines only consists of a few columns, then the columns can be wrapped such that they all fit on one sheet. But is this format acceptable to you?
Another possibility is that your 250000 lines of data don't all need to be read into Excel, such as when you have a file of financial transactions for a dozen stores, but you are only interested in importing the data for one store. If this is the case and the data would therefore all fit on one sheet, the data could be imported using VBA I/O such that only the data not of interest is skipped.
Damon
Yes, a macro can do this. But exactly how to code this macro depends on how you want the 250000 lines imported. For example, do you want the file to be split among several worksheets (four would be required)? If so, do you want it split evenly, or each sheet (except the last) filled all the way to 65536 rows?
If your 250000 lines only consists of a few columns, then the columns can be wrapped such that they all fit on one sheet. But is this format acceptable to you?
Another possibility is that your 250000 lines of data don't all need to be read into Excel, such as when you have a file of financial transactions for a dozen stores, but you are only interested in importing the data for one store. If this is the case and the data would therefore all fit on one sheet, the data could be imported using VBA I/O such that only the data not of interest is skipped.
Damon
Upvote
0
Similar threads
- Question
