Importing large fields from excel to access

[Guest]

I have a spreadsheet that I am trying to import into access. The spreadsheet
import wizard automatically assigns text field to all of the fields. However,
one column has a large amount of data and needs to be a memo field. I don't
see how I can change the data type. How can i change it? When I import text
files, the wizard allows you to select the data type but I don't see that
option for excel files.

 

[MH]

Create the table first, once you have the table set up you can import your
data.

MH

 

[Guest]

I wish that were true, but it isn't. I've created a single-field table, with
that field being a Memo type, but Access still only imports the first 255
characters of the cells.

I'm using a very standard VBA line:

DoCmd.TransferSpreadsheet acImport, 8, "Data", strFileStuff, False,
"InputData"