Memo Field truncated when exporting as .txt - Text file

G

Guest

When I export my query as a Text file, the memo field get truncated.
Any suggestions as to how to prevent this?
Using Access 2003
Thanks.
 
J

John Nurick

This will happen if any kind of formatting or other processing is
applied to the memo field. If you can't remove that, the work-round is
to use a temporary table with fields that match your query. Turn the
query into an append query, and run it to populate the table; then
export the data directly from the table to the text file.
 

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

Top