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

S

srini.yarraguntla

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.
 

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

Similar Threads

insert memo feild into a memo field truncates at 255 characters - 4
Make Table Query Truncating Memo Field at 255 Characters 2
memo field is truncated to 255 characters 4
255 Character Limit for Linked Excel data 1
Excel automation - need more than 255 characters in a cell 4
MS Access COLUMN TRUNCATION after moving data between tables 1
Can't pass string >255 characters to Word document with VBA 3
Why is Excel truncating my text to 255 characters? 2

Top