Getting more than 65,000 records into a table or spreadsheet

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

Howdy,
Does anyone know how to get more than 65K records into a
table or spreadsheet.

I have tried several times and both excel and access won't
let me import or cut and paste more than 65,000 records.
I have seen more than 65k in spreadsheets before so I know
that it is possible.

Please Advise
 
Howdy,
Does anyone know how to get more than 65K records into a
table or spreadsheet.
Click to expand...

It's no problem to get over a million records in an Access table. My
understanding is that Excel is limited to 65536 rows in a spreadsheet
and that there is no way around this limitation; but you might want to
post this question in an Excel newsgroup.
I have tried several times and both excel and access won't
let me import or cut and paste more than 65,000 records.
I have seen more than 65k in spreadsheets before so I know
that it is possible.
Click to expand...

If you could post a specific example it might help. But from the
ExcelXP help file, under Specifications, it's pretty explicit:

Worksheet size 65,536 rows by 256 columns
 
John Vinson said:
It's no problem to get over a million records in an Access table.
Click to expand...

A friend has 100,000,000 records consisting of the daily closing stock
prices. And he can get to any stocks records in less than a second.
Obviously he has indexed the appropriate fields. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
A friend has 100,000,000 records consisting of the daily closing stock
prices. And he can get to any stocks records in less than a second.
Obviously he has indexed the appropriate fields. <smile>
Click to expand...

Cool: a new record to my knowledge! The 20,000,000 record
voter-registration database in Access 2.0 was the biggest that I knew
of.
 
John Vinson said:
Cool: a new record to my knowledge! The 20,000,000 record
voter-registration database in Access 2.0 was the biggest that I knew
of.
Click to expand...

BTW this is for his personal use only. So there are no multi-user or
update issues.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
I finally cracked last week when I saw another message asking
'how many records can you have in an Access Database?'

I suddenly started wondering - how many records can you have?

I can't remember any of the theoretical numbers, so this is
what I have so far:

101 million yes/no records in a 1.6 GB Access 2000 database.
or
69 million yes/no records with primary key autonumber field
in about the same space.

So its looking like somewhere around 120 million useless
records, or less than 100 million almost useless records.


Further contributions invited....
(david)
 
Back
Top