Problem importing Excel worksheet with long strings

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am attempting to create a table using an Excel
spreadsheet which has a couple thousand characters in some
cells. The text strings do not import completely.
 
Dennis

Create a table in Access that has the datatype = Memo for the fields that
will hold "a couple thousand characters". Access' "text" datatype can only
hold 255.

Import the spreadsheet into the table.

Good luck

Jeff Boyce
<Access MVP>
 
I believe that TransferSpreadsheet will not import text strings longer than
255 characters? To import memo-length data, I've had to use Automation to
open the EXCEL file and to read the worksheet's data directly into a
recordset.
 
Thanks, Ken. I was "winging it". The "voice of experience" works better.

Jeff Boyce
<Access MVP>
 
I just imported an Excel file with 2000 characters in a cell, using the
following code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"MemoTest", "c:\Data\AccessTransferMemo.xls", False
 
Thanks for the info, Debra!

It doesn't always work, depending upon how many other cells in the same row
also have data. I've been burned too many times in the past by incomplete
text so I just resort to the Automation !

:-)
 
Back
Top