Importing large cell from Excel

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

Guest

I'm trying to import from Excel via VBA; sure, that's easy with
DoCMD.ImportSpreadsheet. Unfortunately, it has the same limitation as using
the Import Wizard: Excel automatically identifies data types, and any alpha
content causes the data to be imported as a Text field. This limits the data
to 255 characters, and I need more than that. I can format the receiving
field to be Memo, but I can't change the import itself. How would that be
done?

TIA,
 
I already tried that and it did not work. It's just a single field of Memo
size, but it still receive donly 255 characters.
 
Back
Top