Export Query Output To Text File

  • Thread starter Thread starter carl
  • Start date Start date
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 ?
 
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
 
Back
Top