How do I prevent data truncation from access to excel using MS Qu.

K

ktw_jax1

I am using Access and MS Query to move data from Access to Excel. Some of
the fields are Memo or greater than 255 characters. Whenever I refresh,
these fields are being truncated. Is there any way to prevent this?
 

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

Make Table Query Truncating Memo Field at 255 Characters 1
truncation of fields inported from access 1
Mail Merge with Excel and Word 2007 1
EXPORT QUery with memo field to excel, truncated data 2
Merge field truncated to first 18 characters from source? 0
Truncated Excel 255 chars 3
Adding data to MS Access from csv file 0
Exporting to excel is truncating my data 2

Top