I am trying to import an Excel spreadsheet into Access. There are > 255 characters in a few of the Excel cells - and so I have set up the Access field as Memo.
However, when I use the following VB code to import the spreadsheet, the data is getting truncated. What am I missing?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_MASTER_temp", GetFile2, True
Thanks for your help,