Saving access table as a .txt file

D

Dena

I have a database that was created in Access 2000. Some
of our clients have upgraded to Access 2003 and we are
having trouble with a macro. We are trying to save a
table as a .txt file. The macro saves the .txt file
as .txt but it will not put our Company Code in front
of .txt. Here's how we have the macro set up:

Transfer Type: Export Delimited
Specification Name: FinalAudit Export Specification
Table Name: FinalAudit
File Name: ="c:\audit\"&[Forms]![frmFederalMenu]!
[frmCountComplete]!
Code: 
&".txt"

Any suggestions!!

Thanks
Dena
 
Top