Problem importing Excel worksheet with long strings

[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.

 

[Jeff Boyce]

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>

 

[Ken Snell]

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.

 

[Jeff Boyce]

Thanks, Ken. I was "winging it". The "voice of experience" works better.

Jeff Boyce
<Access MVP>

 

[Ken Snell]

 

[Debra Dalgleish]

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

 

[Ken Snell]

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 !