This is an Excel limitation. Excel spreadsheets (in the version to
which Access can export, anyway) are limited to 65536 rows.

You can't fit a gallon of wine into a quart jug.

                 John W. Vinson[MVP]    
   Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Why not test for the number of rows that have to get exported, and do the
export two or more times if the number of rows exceeds the 65K threshhold.
You can control which records are exported with the WHERE statement of your
query.

Excel 2000 and up I believe support more than 65K rows.  If your target
audience is using these versions you can export the data to a tab delimited
file whose name has an XLS extension.  When your user double clicks the file
Excel will open it as though it were in the native excel format.  Give it a
try.

Ron W

worksheet, so data ends up missing from the worksheet.  Is there a way that
I can export the remaing rows of data to another worksheet?
DoCmd.TransferSpreadsheet has a range paramater, is this what I need to use?
Can someone give me an example.