Exporting Memo fields into Excel



I have an extensive query that I need to export into an Excel spreadsheet -
however the memo field only copies over the first 255 characters - is there a
way to bring over the entire memo field? If I bring them over one by one
(copy) it does the whole memo field, but cannot bring over the entire query
with the memo fields. I've got over 1400 records in this query - how can I
bring over everything to excel including the full memo fields.
Thanks very much!


I had that problem several years ago, and don't exactly recall how I dealt
with it. Try using Excel to pull the data from Access rather than pushing it
from Access to Excel.

In Excel, go to the Data menu option and select "Import External Data" and
in the submenu that pops up, select "New Database Query".

In the dialog box, select "MS Access Database" and in the next dialog,
select the file that your query resides in, and then select the query you
want to use.


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