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

[dowlingm815]

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?

[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

[NeoPa]

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.

[dowlingm815]

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

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.

[NeoPa]

Ah. That makes a lot more sense than the original question did.

Glad you got it sorted anyway.