export from access to excel

[warwick]

I am running MS office in XP. My problem is when I export to excel some do
not show. i.e. up to and including row 1807 show (each with 21 columns)
={37947 cells} any data after this row will not go or show in excel. Is there
a limit on export and if so how do you override it?
thanks warwick

 

[Jeff Boyce]

How are you 'exporting to Excel'? Are you copying/pasting? Are you using
the Transfer method?

More info, please.


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jerry Whittle]

There are limits, but not that few of rows. You should be able to export
16,000 rows easily.

Describe exactly how you are doing the export to Excel. There are many
different ways and some work differently than others.

Also are you exporting memo fields? Do you get any error messages in Access.

Try this: Make a backup of your database. Then do a compact and repair of
the database. It's possible that there is a corruption problem interfering
with the export.