[AccessD] Import more than 255 characters from Excel

I have a memo field in an Access table, and it receives data from an
imported Excel sheet. Unfortunately, the import cuts the length of the
imported data to 255, since Access automatically considers it a Text field.
Is there a way around this? I use the very simple line:

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

I tried defining the table, "Import01", as filled with Memos; no
difference. Any help? I really need to import more than 255 characters. Is
there a setting in here somewhere? The spreadsheet is too complex to export
to a .CSV file, BTW. Also, "InputData" here is a named range.

TIA.


Thomas F. Ewald
FCS Database Manager
General Dynamics Land Systems
(586) 276-1256





This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.