Import from Excel truncates

[Chanda]

Re: https://www.accessforums.net/import-...emo-26861.html



Similar situation for me. I removed the "@" as well, but the data is still being truncated. Any suggestions?

[June7]

Same suggestion, provide the file for analysis.

[ranman256]

Is your target field set to MEMO? (the only field that can be longer than 255)

[Chanda]

ranman256 It is set to Memo. Strangely, after going through all fields, I found that the truncated data was sporadic. If it were all the data more than 255, it would make sense, but it isn't. A lot of troubleshooting, but no luck.

[AnandKhinvasara]

If your Import excel contains memo fields having more than 255 characters,import it using TransferSpreadsheet method. You can paste it under a command button on a form, and change the variable names.

docmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "TableName", "C:\InputFilePath\InputfileName.xls", True

If still it doesnt work, then link the spreadsheet instead of importing it, and then use it in your queries/or forms or whereever.