Export reports to Excel

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Hai,

When I export a report from Access to Excel with a remarks
field in it, I have the problem that all the remarks are
exported. This probably because a cell in Excel can only
handle 255 characters.

Can this be changed?

thanx

Frank
 
I belive that is the limit for Excel but to be sure you might want to ask in
an Excel newsgroup.
 
If you use TransferSpreadsheet, memo fields won't export correctly to EXCEL.
The way to get around this is to use VBA code to open a recordset based on
the table or query that you wish to export, open the EXCEL file via
Automation, and then loop through the recordset and write the values
directly into the cells in the EXCEL spreadsheet.
 
Back
Top