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

Import Excel file into Access, does it have a row limitation?

100+
P: 133
I am importing an Excel 97-2003 file into Access 2003. The number of rows within the Excel file is 101,9992. When completed the Access import, only 65,535 are import.

Is Access limited, if so, does anyone know a work around?
Apr 19 '10 #1

✓ answered by patjones

I'm sort of surprised to hear that you have that many rows in the Excel file; pre-Excel 2007 has a row limit of 65,535...which corresponds exactly to the number of rows that you were able to successfully import in Access.

You could just split the Excel data into two smaller sheets (<65,535), and then import those separate sheets into two corresponding tables in Access. Once in Access, an append query can put them back together again.

Pat

Share this Question
Share on Google+
4 Replies


patjones
Expert 100+
P: 931
I'm sort of surprised to hear that you have that many rows in the Excel file; pre-Excel 2007 has a row limit of 65,535...which corresponds exactly to the number of rows that you were able to successfully import in Access.

You could just split the Excel data into two smaller sheets (<65,535), and then import those separate sheets into two corresponding tables in Access. Once in Access, an append query can put them back together again.

Pat
Apr 19 '10 #2

NeoPa
Expert Mod 15k+
P: 31,492
When you say you have that number (I'm not sure which number it represents as it's in a strange format with four digits grouped together) of rows in an Excel spreadsheet, how many sheets are involved? I know that each sheet has a maximum of 65,536 rows for those compatibility files so I'm also struggling to understand what you are trying to say.
Apr 20 '10 #3

100+
P: 133
@zepphead80
the file was an excel 2003 which limited it to 65k. when it was imported from 2007 .xlsx, the file had a 101k record count. therefore instead breaking it up in chucks, it was imported into access 2007 which accepted all the records.
Apr 23 '10 #4

NeoPa
Expert Mod 15k+
P: 31,492
Ah. That makes a lot more sense than the original question did.

Glad you got it sorted anyway.
Apr 23 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.