I have the following code in a onclick event of a command button on a form. But the problem I'm having is with a certain cell in the Excel file. It has a lot of copy in it but the import function seems to be cutting it off after 255 characters. Can someone help me? I need to import all of the copy in that cell. The field in the table the Excel file is being imported into is a memo field.
Here's the import code:
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.InitialFileName = Environ("userprofile") & "\Documents\"
If .Show Then
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempFieldNotesImport", .SelectedItems(1), False, "A1:B66"