Memo field in Access 2003 is truncating the data

S

Susan May

I am importing data from Excel into Access and it is truncating the comments
field which we have set up in a Memo field. How do I rectify this problem?
 
K

Ken Snell \(MVP\)

Use TransferSpreadsheet (macro or VBA) to do the import; and specify the
most current version of EXCEL in the argument for selecting the EXCEL
version. If you use File | Get External Data ... | Import method, it uses
an older EXCEL version and will truncate strings longer than 255 characters.
 

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
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
import csv truncation 1
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
.MDB memo fields being truncated during Word merge 0
Access 2003 memo field truncated while exporting as RTF 0
transfer to excel 1
Make Table Query Truncating Memo Field at 255 Characters 1

Top