export access memo fileds to excel

P

pankos

Hi,
I'm using fileds as memo data type in my (2003) access database tables.
When i'm trying to export/transfer that data to excel (export or copy/paste
or via pivot table etc.), i have only 255 characters and the rest characters
cut.
Any assistance with this will be gratefully appreciated.
Thanks in advance
 
K

Ken Snell MVP

Use macro or VBA to run TransferSpreadsheet action. It will not truncate
memo fields' contents from a table.
 

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
Export Access Table with Memo Field to Excel 2
Exporting memo fields from Access to Excel 3
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
Linked table column type changes from text to memo 1
exporting data to Excel 1
Dealing with the error: unable to filter on excel hc home school 0
Export Access pivot table to Excel 0

Top