acImport, acSpreadsheetTypeExcel9, _
"Test", fullPath, True)
1) I ran this vba in the attached test docs and it DOES work (does not truncate)
2) I changed the target table name in my main app, aimed at my "real" spreadsheet, and it DOES truncate
3) When I run this in my attached test app on my "real" spreadsheet it DOES truncate.
4) I stripped everything out of my real xls, except the one row that has a cell that's bigger than 255 char, and leaving the header rows, and it DOES NOT Truncate
SO, there's something in my "real" spreadsheet, independent of the Access app, and not in the row with the one big cell, that causes the data to truncate at 255 chars. There's nothing in the design or processing of the real xls that makes me think that that row is any different than any other row.
Unfortunately I can't share my full "real" spreadsheet. I'm hoping someone has observed this behavior before and knows what might be going on.
Any help with this would be appreciated.