Transfer Spreadsheet

DZ · Jan 29, 2008

In Access 97, if one imports Excel Spreadsheet data that contains text longer
than 255 as acSpreadsheetTypeExcel3, will the data in the text fields be
truncated?

Thanks

Ken Snell \(MVP\) · Jan 29, 2008

Yes, Use acSpreadsheetTypeExcel9 instead.

Transfer Spreadsheet

DZ

Ken Snell \(MVP\)