I have an import command that is truncating a memo field
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tblCashPro", gSelectedFile, False, "A1:T1000"
tblCashPro is a table that matched the structure of the spreadsheet. The last field in the sheet is a memo field. I have defined it as such in the table and i have removed formatting restrictions (I looked at all of the other comments in the Experts DB). No matter what i do the memo field is truncated to 255.
I am out of options.
Thanks in advance.