- Joined
- Mar 30, 2021
- Messages
- 1
- Reaction score
- 0
My requirement is to load data from excel spreadsheet to MS access table.
Excel spreadsheet has one Column for Long Text data. The column has less than 255 characters data for the first line/record and more than 255 characters data for all other lines/records.
When transferspreadsheet command is used to import data into access table, the column value is truncated to 255 characters even though access table column defined as Long Text.
How can I load complete data without limiting to 255 characters.
Excel spreadsheet has one Column for Long Text data. The column has less than 255 characters data for the first line/record and more than 255 characters data for all other lines/records.
When transferspreadsheet command is used to import data into access table, the column value is truncated to 255 characters even though access table column defined as Long Text.
How can I load complete data without limiting to 255 characters.