Saving Acces tables 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 table as
a .txt file, but it will not put our Company Code in
front of .txt. Here's how the macro is set up:

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

Any Suggestions!!

Thanks
Dena
 
S

Steve Schapel

Dena,

What name is the text file being saved as?

Normally the syntax should have spaces around the &s, i.e.
="C:\audit\" & [Forms]![frmFederalMenu]![frmCountComplete]!
Code: 
 & ".txt"

Also, where is the macro being triggered from?  For example, if it is
activated from an event on the frmFederalMenu form, try it like this...
="C:\audit\" & [frmCountComplete].[Form]![Code] & ".txt"
 

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

Export table to txt file with a variable filename 0
Transfer text delimited with date in file name using a macro 3
macro to export table to .txt file revisited 3
Export Table Records to txt file 1
Auto Open Macro of external .txt file based on cell reference 1
Error When Using TransferText in a Macro 1
Export a table to text file with file name depending on certain da 12
Access Transfer Text -how to save current date as file name 1

Top