Import From Excel To Text(64000) Data Type.

[amayne]

I am attempting to import data from excel to a text(64000) field in an existing table, using the 'update' action.

 

this problem is... the import is truncating the notes field at 255 characters.  during the import, it seems to automatically decide it is text(255).  the only way i can force it to import as text(64000) is to create a new field, instead of updating the existing field.

 

In the table design, the notes field to be updated is definitely text(64000).  am i missing something?

 

regards

~allen.

[amayne]

Same result with REPLACE, but i found a fix...

 

The import (update) with text(64000) field works fine from the older '.xls' excel format, but not from an .xlsx workbook.

 

thanks

~allen

[LWSChad]

For now, as a workaround, try:

 

1) export table

2) in excel add the text(64000)

3) REPLACE rather than UPDATE

[AladdinPlumbing]

i am facing the same issue, please if you got the solution share with me.