Line Limit Exporting to Excel Failure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top