Memo fields truncated in Access query, how to fix and export to excel?
Posted on 2011-09-05
Hello, I have a query which contains several memo fields. I want to export the results of this query to Excel, but within Access 2007 the memo fields are truncated in the query. How can I change this and make a clean export of the query and data? In the Access query I use a few SQL commands: IN() HAVING() WHERE() and INNER JOIN() as well as merging some text fields. Can anyone offer me any advice?