Append Query Character Limit

[benkingery]

I have an append query that takes data from one table and writes it to another. What I'm finding, however, is that it will only write the first 255 characters, and it leaves off everything else.

Once in the destination table, I have fixed many of these fields so they contain the full data that was originally intended. Next I have a process which exports the data from that table into Excel. I'm finding that the export will also only output 255 characters.

Does anyone know of a 255 character limit with Access and queries or outputting objects to Excel?

Note: I'm using Access 2003 as the front end, but the data is actually stored on a linked SQL Server 2005 Table where data type is Varchar(2000). In Access, the datatype is Memo.

 

[John Big Booty]

If you are using a text box to store this data, it is a problem with the size limit of a text box (Max of 255 characterise) rather than with the query.

If you use Memo fields to store this data you will not have this problem

 

[benkingery]

I'm not really sure how the fields in the form would be relevant. I can verify that the data is being store properly on the tables. The datatype being used in the table is Memo. The behavior only occurs when the data is appended from one table to another or when it is exported to excel.

Any other ideas?

 

[boblarson]

Perhaps this will help.

 

[benkingery]

Thanks boblarson. Funny enough, I was just looking at that site. Do you know if the help under the following URL will provide me with what I'm looking for? Specifically I'm exporting a Query to excel, not a report. I'm not sure if that changes any assumptions. Let me know your thoughts.

http://support.microsoft.com/kb/208801

 

[boblarson]

If your query is using any of the things that are listed in Allen's webpage, then you should create your initial query without the memo field and create a separate query with ONLY the memo field. Then, link the two together in another one and export that.