O
Oak N.
Hi there,
I'm trying to import a spreadsheet that contains a
column of text where individual cells sometimes exceed
255 characters. Every time I import the spreadsheet,
access makes that column field a text field and truncates
the text at 255. I've tried exporting to a tab delimited
file and importing it that way where I can specify the
field type but it still truncated the cells.
I've tried doing a linked table, but it still truncates
the text and won't let me change the field type to memo.
Can anyone tell me how to get this to import correctly?
Thanks,
Oak
I'm trying to import a spreadsheet that contains a
column of text where individual cells sometimes exceed
255 characters. Every time I import the spreadsheet,
access makes that column field a text field and truncates
the text at 255. I've tried exporting to a tab delimited
file and importing it that way where I can specify the
field type but it still truncated the cells.
I've tried doing a linked table, but it still truncates
the text and won't let me change the field type to memo.
Can anyone tell me how to get this to import correctly?
Thanks,
Oak