Importing 4 million records

billb

New Member
Joined
Jan 20, 2004
Messages
4
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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
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
 
Upvote 0

billb

New Member
Joined
Jan 20, 2004
Messages
4
Yes, I would like Excel to keep adding pages to accomodate all of the data.

Thanks!
Bill
 
Upvote 0

anvil19

Board Regular
Joined
Nov 18, 2003
Messages
230
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
:eek:
 
Upvote 0

billb

New Member
Joined
Jan 20, 2004
Messages
4
I will give that a try. Thanks for the suggestions and the quick responses!

"I'll be back"
Bill
 
Upvote 0

Forum statistics

Threads
1,186,916
Messages
5,960,554
Members
438,484
Latest member
supermon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top