<div>
&lt;...run off a list of all the codes&gt; <br />
<br />
what list of codes are you referring to?<br />
<br />
to &nbsp;use automation to export queries/table to a text file, you will need export specification..<br />
<br />
see this link<br />
<br />
<a href="http://support.microsoft.com/?kbid=208991" rel="ugc">http://support.microsoft.com/?kbid=208991</a><br />
<br />
after creating the export specification, you can use this command to export the queries or tables<br />
<br />
<br />
DoCmd.TransferText acExportDelim, &quot;ExportSpecName&quot;, &quot;TableNameOrQueryName&quot;, &quot;C:\myText.txt&quot;, True<br />
<br />
<br />
<br />
&lt;I have Access 2003 now but I am getting Access 2010 soon so I dont know if the new version has something that I can use for this. &gt;<br />
<br />
yes, you can still use the export specification that you created in A2003.<br />

</div>


<...run off a list of all the codes>

what list of codes are you referring to?

to  use automation to export queries/table to a text file, you will need export specification..

see this link

http://support.microsoft.com/?kbid=208991 [http://support.microsoft.com/?kbid=208991]

after creating the export specification, you can use this command to export the queries or tables


DoCmd.TransferText acExportDelim, "ExportSpecName", "TableNameOrQueryName", "C:\myText.txt", True



<I have Access 2003 now but I am getting Access 2010 soon so I dont know if the new version has something that I can use for this. >

yes, you can still use the export specification that you created in A2003.


<div>
<div class="content wysiwyg-content">
I have a list of codes that I need to create a text file for each code in my query. I am able to see what I want in my query and even export it with a single code in the queyr but I am wanting to automate the process to run off a list of all the codes(via table or query) in an automated fashion. I have Access 2003 now but I am getting Access 2010 soon so I dont know if the new version has something that I can use for this. <br />
<br />
I need help in figuring out what way would be the best. <br />

</div>
</div>


I have a list of codes that I need to create a text file for each code in my query. I am able to see what I want in my query and even export it with a single code in the queyr but I am wanting to automate the process to run off a list of all the codes(via table or query) in an automated fashion. I have Access 2003 now but I am getting Access 2010 soon so I dont know if the new version has something that I can use for this. 

I need help in figuring out what way would be the best. 


Export Access Query (or report) to text files

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.