Newbie Excel to Access

[Linda]

I have an Excel spreadsheet that I need to convert to an
Access .mdb file. There are 5 columns that only contain
numberic data (no problem here) and the 6th column
contains text usually with more than 255 characters.

When I use the Import function in Access to a new table,
it converts the first 5 columns just fine. In the 6th
column, the text is truncated. I also have created a
table in Access and designated the 6th column as a memo
field and imported the data to this existing table. It
still truncates my data.

What can I do differently to make sure that all of the
data is transferred to the .mdb file?

TIA,
Linda

 

[Roger Carlson]

You might try saving the spreadsheet as a comma delimited file (.CSV), and
then import that.