By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Import

P: n/a
When I imported a spreadsheet that has more than 220,000 rows, how come I
always get 64,999 in the access? Any way I can change to get them all? Is
this to do with RAM?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Sherman H." <sh***@earthlink.net> wrote in message
news:gl******************@newsread1.news.pas.earth link.net...
When I imported a spreadsheet that has more than 220,000 rows, how come I
always get 64,999 in the access? Any way I can change to get them all? Is this to do with RAM?

Where are these 220,000 rows? In one spreadsheet?
I thought Excel had a limit of 65,536 rows per sheet.
Nov 12 '05 #2

P: n/a
Sherman H. wrote:
When I imported a spreadsheet that has more than 220,000 rows, how come I
always get 64,999 in the access? Any way I can change to get them all? Is
this to do with RAM?

Try converting the file to a text or text delimited file.

I just tried creating a spreadsheet with more than 65,000 rows.
Excel97 and Excel XP stopped at 65,536. Maybe your file isn't a true
excel file.
Excel95 or earlier can only go just over 16,000 rows.

HTH
Ron
--

Ronald W. Roberts
Roberts Communication
rw*******************@robcom.com
To reply remove "_at_robcom_dot_com"

Nov 12 '05 #3

P: n/a
Sherman H.,
Excel can exceed the 65,536 row limit of its own worksheets if the data does
not originate in Excel. At 220,000 rows, I suspect what you are looking at
is a connection to an external data source such as SQL Server or Oracle. It
may also be Access, but without inspecting the worksheet in question it's
hard to say. If what you have is a connection to an external data-source
then getting it all is a matter of asking access to connect to the same
external source.

"Ronald W. Roberts" <rw*@robcom.com> wrote in message
news:10*************@corp.supernews.com...
Sherman H. wrote:
When I imported a spreadsheet that has more than 220,000 rows, how come I
always get 64,999 in the access? Any way I can change to get them all? Isthis to do with RAM?

Try converting the file to a text or text delimited file.

I just tried creating a spreadsheet with more than 65,000 rows.
Excel97 and Excel XP stopped at 65,536. Maybe your file isn't a true
excel file.
Excel95 or earlier can only go just over 16,000 rows.

HTH
Ron
--

Ronald W. Roberts
Roberts Communication
rw*******************@robcom.com
To reply remove "_at_robcom_dot_com"

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.