Does Access always truncate to text field?

M

morningfrost120

I know that Access truncates to 255 characters during an export function, but
I just tried a straight up copy and paste from an Access table to Excel and
it still truncated to 255 characters. Is there any way around this?
 
K

Ken Snell [MVP]

Use the TransferSpreadsheet action and choose the most new version of EXCEL
as the format for the export. See Help for more details.
 

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

Mail Merge with Excel and Word 2007 1
Make Table Query Truncating Memo Field at 255 Characters 1
255 truncation 1
Importing from Word to Excel - truncated 1
Merge field truncated to first 18 characters from source? 0
truncation of fields inported from access 1
Function to find truncated entries? 3
EXPORT QUery with memo field to excel, truncated data 2

Top