EXPORT QUery with memo field to excel, truncated data

B

BlueWolverine

Hello,
MS OFFICE (ACCESS/EXCEL) 2003 on XP PRO.

I have a query with several fields, one being a memo. I want to export the
query to an excel file. When I do this, the data in the memo field truncates
to 255 characters. This is a problem for me.

Is there any way around this problem?

Thanks,.
 
B

BlueWolverine

If you export to XML instead of Excel you can work around this problem. You
have to open the output in excel, convert to range and format the affected
cells as GENERAL. :)
 
K

Ken Snell

Export to EXCEL using TransferSpreadsheet (via a macro or VBA code). It
handles memo fields without truncating the data string.

Using File | Export or using OutputTo (via a macro or VBA code)
will truncate memo fields.
 

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

TransferSpreadsheet still truncates the memo field 1
export access memo fileds to excel 1
Export Access Table with Memo Field to Excel 2
output memo to RTF 2
Make Table Query Truncating Memo Field at 255 Characters 1
Embedded Excel into Word with Tables 0
Access 2003 memo field truncated while exporting as RTF 0
Importing Excel Data Into MS Access Memo Field 1

Top