Memo datatype not importing past 255 characters

[Dave_D]

After several Googles, I'm consisting reading where a text string longer than 255 characters will truncate using the Transferspreadsheet command into the DB if the first 25 rows of Excel ends up not containing a text string over 255 characters even though the datatype is Memo. If I move record say 36 to record 3, I have no issues. Is there a work around for this? Thanks!

[rpeare]

perhaps try linking the spreadsheet, then appending the records to your table but I suspect you will find the same trouble. Are you transferring into an existing table or creating a new table on the import?

[Dave_D]

This is being transferred into an existing table.

[rpeare]

Have you thought about not using the transferspreadsheet method then? Perhaps loading the spreadsheet as a recordset then cycling through the recordset to add data?

[Dave_D]

Yes I have. I was just hoping for a quicker solution

[rpeare]

I don't know how far you want to go with this but it might be possible to re-sort the excel file sorting by the longest memo field first prior to your import, that may take longer than inserting records 1 by 1 though. I don't know how large your file is.

[Dave_D]

I've given that some thought as well. Thank you for all of your feedback!