Importing large cell from Excel

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,
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing an Excel File 1
Type Conversion Failure importing number as text 1
Importing Excel Data Into MS Access Memo Field 2
Importing Text Fields in Excel 2
Importing large fields from excel to access 2
Importing an excel field that contains - data type mismatch 3
Importing Excel w/ >255 fields 3
Importing Text Files Into Access 1

Top