Every time I try to export or copy/paste records to excel or word, long memo fields get truncated. I can manually copy/paste the field without trouble. However, manually copying and pasting hundreds of records is not feasable. Does anyone know what is going on? As always, your help is greatly appreciated.
Exporting to Excel/Word Truncating Problem
- Thread starter jbruno
- Start date
SteveA
Registered User.
- Local time
- Tomorrow, 07:54
- Joined
- Oct 8, 2001
- Messages
- 126
I was having the same problem when programmatically exporting data to excel from Access 97.
The standard export always truncated the value to a maximum of 255 characters.
I had to place the result in a CVar() function to prevent the truncation from occurring. Unfortunately, this only works where I am using VBA to write my data to excel. It doesn't work with the Analyze with Excel toolbar option provided by Excel.
If anyone does know how to do this directly from a query, I would love to know.
Cheers,
SteveA
The standard export always truncated the value to a maximum of 255 characters.
I had to place the result in a CVar() function to prevent the truncation from occurring. Unfortunately, this only works where I am using VBA to write my data to excel. It doesn't work with the Analyze with Excel toolbar option provided by Excel.
If anyone does know how to do this directly from a query, I would love to know.
Cheers,
SteveA
