Exporting a query to a text file

[meadt]

Hi Guys,

I'm trying to export the results of a query to a text file using the code below:

DoCmd.TransferText acExportDelim, "DE16 Import Specification", "Query1", "c:\winnt\PROFILES\mead_t\Desktop\testing.txt"

But when I run it I get the error:

The Microsoft Jet database engine could not find the object 'test.txt. Make sure the object exists.

When I do this with a table it works fine.

Cheers

T.

 

[SOS]

Do you have any other code in there as well?

 

[meadt]

No thats it, its linked to a command button on a form.

 

[DCrake]

The script says testing.txt your comments say test.txt is this a typo? Does the actual path exist?

 

[namliam]

DoCmd.TransferText acExportDelim, "DE16 Import Specification", "Query1", "c:\winnt\PROFILES\mead_t\Desktop\testing.txt"

Besides what David said, also consider your naming conventions