Importing 4 million records

[billb]

Can't figure out how to overcome the size limitation in Excel. I have a comma delimited file with 4 million, over 24,500 pages, of records. Only 6 column topics but a lot of data! How do I get all of that into one workbook, or spreadsheet? I have tried to manually subdivide the data but that is painful!

Any help and understanding for a novice appreciated.
Bill

 

[SIXTH SENSE]

hi!
What are you trying to do? do you want to go to next sheet when the first sheet reaches row 65536?
I think it is possible with VBA

 

[billb]

Yes, I would like Excel to keep adding pages to accomodate all of the data.

Thanks!
Bill

 

[anvil19]

Hi billb, Welcome to the Board

This seems to me to be a job best done in Access or another databse rather than a spreadsheet.

Doing as SIXTH SENSE suggests :

do you want to go to next sheet when the first sheet reaches row 65536?

will require just over 61 sheets. That's a lot of sheets to keep an eye on.

Access will accept all those records (as long as the database size is below 2Gigs) and you can then use Excel to manipulate the results of a query or two.

What about that?

anvil19

 

[billb]

I will give that a try. Thanks for the suggestions and the quick responses!

"I'll be back"
Bill