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

Export Access Table with Memo Field to Excel 2
export access memo fileds to excel 2
Export Memo field to Excel 4
TransferSpreadsheet still truncates the memo field 1
Access Export Problem 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Make Table Query Truncating Memo Field at 255 Characters 2
Memo fields are truncated when including the textdelimiter char e. 2

Top