<div>
TransferSpreadsheet did the trick. &nbsp;Thanks.
</div>


TransferSpreadsheet did the trick.  Thanks.

<div>
<div class="content wysiwyg-content">
I had this problem once before and thought I had it solved but I guess not.<br />
<br />
I'm trying to import an Excel file into a table in Access 2013. &nbsp;One of the fields contains many more than 255 characters but the import process WILL NOT import more than the first 255 characters! &nbsp;Is very frustrating.<br />
<br />
I have done what some exports suggested before including:<br />
<br />
1) Be sure one of the first 25 rows I the Excel file have more than 255 characters. &nbsp;Actually, they all do.<br />
2) Link to the Excel file and try an append query to the table. &nbsp;Doesn't work either.<br />
<br />
Any other thoughts?<br />
<br />
--Steve
</div>
</div>


I had this problem once before and thought I had it solved but I guess not.

I'm trying to import an Excel file into a table in Access 2013.  One of the fields contains many more than 255 characters but the import process WILL NOT import more than the first 255 characters!  Is very frustrating.

I have done what some exports suggested before including:

1) Be sure one of the first 25 rows I the Excel file have more than 255 characters.  Actually, they all do.
2) Link to the Excel file and try an append query to the table.  Doesn't work either.

Any other thoughts?

--Steve

Cannot import more than 255 charaters from an Excel cell to a table field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.