I am importing xlsx files via fileopendialog. The Excel file chosen may be different each time in structure.
The code I am using to import is:
The issue is when the cell in Excel has a string of more than 255, it gets truncated.
How can I create a new table based on the Excel file selected and import the full text of each cell?
The code I am using to import is:
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
Replace(strTable, ".xlsx", ""), strPathFile
The issue is when the cell in Excel has a string of more than 255, it gets truncated.
How can I create a new table based on the Excel file selected and import the full text of each cell?