Exporting memo fields from Access to Excel

C

cfolk

When I export a memo field from Access to Excel, I am not receiving all the
information from that field - only a limited number of characters.
 
K

Ken Snell \(MVP\)

Use TransferSpreadsheet action (macro or VBA) to do the export. Using the
File | Export option will truncate memo fields.
 
R

ragav_oo1

Joined
Mar 21, 2014
Messages
1
Reaction score
0
Hi,

I have tried using the same Transferspredsheet options while exporting and it is working for only one record(without truncating).

If I tried with many records the it is not working.

Kindly help me on this.

Regards,
Ragavan
 

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 QUery with memo field to excel, truncated data 2
TransferSpreadsheet still truncates the memo field 1
exporting data to Excel 1
MS Access and Export to Excel 3
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
transfer to excel 1
Losing data from memo field when exporting to Excel 6
export access memo fileds to excel 2

Top