truncated data from linked excel worksheet?

A

amk

I have linked tables between excel and access 2003 that contain cells with
text. In excel they are formatted as "general" and in access they are
formatted as a memo field. However in the Access table, it truncates the data
to about 250 characters. I don't appear to have an input mask or a format
defined - but I am new at this. Any help would be much appreciated - thanks!
 

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

access is truncating data from a linked table? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
EXPORT QUery with memo field to excel, truncated data 2
Access 2002 truncates text when linking to Excel 2002 1
255 Character Limit for Linked Excel data 1
Importing Excel Data Into MS Access Memo Field 2
Make Table Query Truncating Memo Field at 255 Characters 2
Keeping Format Importing From Excel 8

Top