Line Limit Exporting to Excel Failure

B

BCP

When I try to send the results of a Query/Form Contents to Excel using the
sendobject function or Analize IT with Excel from the tool bar I am getting
an error stateing I have exceeded the line limit for the application (< 20K).
If I export the data to text first I can open the text file in Excel. I
need to be able to unload the full 64K of records to Excel.
 
R

Rick Brandt

BCP said:
When I try to send the results of a Query/Form Contents to Excel using the
sendobject function or Analize IT with Excel from the tool bar I am getting
an error stateing I have exceeded the line limit for the application (< 20K).
If I export the data to text first I can open the text file in Excel. I
need to be able to unload the full 64K of records to Excel.
Click to expand...

Those functions always assume an older version of Excel that was limited to
about 16000 rows. Use the TransferSpreadheet command instead. It allows you to
specify the version.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to Excel 0
nk into onenote 2016 paragraph from excel 2016 cell 0
Export Record Limitations 1
Exporting to Excel 2007 1
How do I export large query results? 5
Export to Excel - calculated field type conversion issue 0
Export Access table to Excel that has more than 65000 records 8
Problems exporting large query results to text delimited format 2

Top