EXPORT DATA TO EXCEL

[AOQUSER]

Hi can anyone help me out here,i'm having problem exporting data to excel using docmd,


Error 2306, The error i'm getting is " THERE ARE TOO MANY ROWS TO OUTPUT, BASED ON LIMITATIONS SPECIFIED by THE OUTPUT FORMAT OR BY MICROSOFT OFFICE ACCESS
PLEASE TELL ME HOW INCREASE THE LIMIT.

This is the script i'm using
DoCmd.SendObject acSendTable, "DATA", "Microsoft Excel 5-7 (*.xls)", " ", , "BAG DATA EXPORT", " Mick, Please find the attached Data", no

 

[BobStubbs]

How many rows do you have in your table?

Excel 2000 has a limit of 65,536 rows for a worksheet, so if you try to export more than this number of records, your export will fail.

I hope that this helps.


Bob Stubbs

 

[AOQUSER]

Hi Bob, I have 40,000 rows and it fails, but with 8,000 it works, If you have any idea to increase the size i would be greatful, Thanks

 

[KenReay]

Hi

the limit is an Excel Specification limit, it cannot be increased

You could use a query to limt the rows returned and send 'n' spreadsheets

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JTinVA]

Okay ... I realize it's six months later but I just had the same problem and here's what I found: According to MS Article No. 201589, Access is set up to be compatible with Excel 5.0's limitation of 16,384 rows. Here's the workaround: when exporting the query results, do NOT select the "Save Formatted" option and it exports fine. Alternatively, you can open an Access query through Excel or export the query as a text file. Hope this helps ...