Import from excel to memo field in Access is truncated after 255 chars

[paullem]

Hi,

I'm importing data from an excel spreadsheet to an MS Access (2003) table. One of the fields in the table is a memo field as the excel cell contains more than 255 characters. But when the data is imported from the excel cell into the memo field it is truncated after 255 chars. Is there a way around this?

Many thanks for any help

 

[MazeWorX]

Change the data type of the table?

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[paullem]

Hi MazeWorx,

I'm not quite sure what you mean?

Thanks

 

[StarPassing]

Check out this thread.

thread181-1349692