export access data to excel

[Jay]

I hope this is not old question.

My acess table has 180,000 records.
When I export to Excel using export ( File), it truncated to about 65K row
in EXcel.
Is there anyawy that I can export whole access data to excel.

Thanks.

 

[Damian S]

Hi Jay,

You have reached the row limit in the version of Excel you are using... Do
you need all of your data to be exported at once, or could you potentially
split it up?

Also, why do you need it in Excel? You may be able to achieve what you need
to do in Access.

Damian.

To confirm that your

 

[Charlie Hoffpauir]

I hope this is not old question.

My acess table has 180,000 records.
When I export to Excel using export ( File), it truncated to about 65K row
in EXcel.
Is there anyawy that I can export whole access data to excel.

Thanks.

I believe you reached the limit of number of rows allowed in Excel. To
export all your Access data, you'd have to use several Excel
spreadsheets, or restrict the amount of data exported.

Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[Graham Mandeno]

Hi Jay

It's the limitation on the size of an Excel worksheet (65,536 rows by 256
columns)

If you want to export more that 64K records, you will need to do it in
chunks, with each chunk going to a different worksheet.

 

[Jay]

Since this data is going to be distributed to management, Excel is preferred.

 

[Damian S]

Perhaps management would prefer the data summarised?