Export reports to Excel

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
 
G

Gina Whipp

I belive that is the limit for Excel but to be sure you might want to ask in
an Excel newsgroup.
 
K

Ken Snell

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.
 

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

Solved Disk Full error message when exporting PDF 0
Adding Cost Field to Appointment 0
Images are pixelated when saving to PDF 0
Converting isse with Export in Outlook 0
exporting report fields to spreadsheet 1
Exporting reports to Excel. 1
VBA - exporting serial letters to single documents 0
CanShrink question Access 2000 2

Top