The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database

Mar 30, 2021
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question