Memo field in Access 2003 is truncating the data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top