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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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
 

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
 

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:
 

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,095
Messages
5,768,054
Members
425,451
Latest member
JohnBrooksBiddle

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