Excel Spreadsheet file size limit?

[abradford]

Is there a size limit to an excel spreadsheet import into access? I have a spreadsheet that is constantly growing, it had 667, rows(1326 kb)yesterday and imported into a new table fine. Now it has 753 rows (1,441 kb)and won't import..."an error occurred while importing..." I deleted some rows, and it worked. How do it get around this?

 

[Remou]

There is a limit of 250, as far as I recall, on columns, but no row limit, as such. Have you tried importing the rows that won't import by themselves? It seems likely that there is an error in one of them.

 

[abradford]

is there another way to import besides the Wizard?

 

[Remou]

You can use TransferSpreadsheet, you can link to the Excel sheet and use a make table query, and you can save as CSV and read in the lines one by one.

 

[abradford]

hmm, ok not to great with code, where can i find instructions on how to do this?

 

[Remou]

You can search in these fora and Help for the various keywords associated with the different options.

 

[fneily]

How about copy and paste?

 

[dhookom]

I expect some of your rows in Excel don't conform with expected data types. Do you get a table of import errors?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]