Export Query Output To Text File

C

carl

I have a query that produces too much data for a copy/paste. Is there
a way for me to get the query result to a text file ?
 
J

John W. Vinson

I have a query that produces too much data for a copy/paste. Is there
a way for me to get the query result to a text file ?
Click to expand...

Sure. Depends on what version of Access you have; in 2003 or earlier, it's
File... Export and select the query, in 2007/2010 use the External Data tab.
In either case you can just export the query itself, and you will have some
choices about the format.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 

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

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Create a dynamic master file 1
Paste Link and Link Text From Browser to Word 0
Outlook 2021 export question 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Outlook Backup issues 0
WordPad blocked content 2

Top