Importing large fields from excel to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 
Back
Top