Problem using DoCmd.TransferText acExportDelim - when outputting a Crosstab Query Access2K

B

bomber

Hi all,

I have a routine that outputs 3 files, 2 of them work fine - they are
standard queries.
One doesn't work. It is using the following code and is a Crosstab query.

DoCmd.TransferText acExportDelim, "ExportSpec_QryRMUNITS_Crosstab",
"qryRMUNITS_Crosstab",
"\\SERVER\MAPPING\service_data.txt", -1

I get an error "The Microsoft Jet database engine could not find the object
'service_data.txt'. Make sure ..."

The crosstab query "qryRMUNITS_Crosstab" works fine when it is run.

Any ideas ?

Adam
 
G

Guest

Adam, your command looks good. You usually get that error
message when you are trying to import using acImportDelim
and the file does not exist. You can also check to make
sure the network path is correct(but you would get a
different error msg if it were not). If you cannot see
any issues, troubleshoot by creating the text file in the
folder where you want to export the data and run the
command again and see what happens. Jeff

-----Original Message-----
Hi all,

I have a routine that outputs 3 files, 2 of them work fine - they are
standard queries.
One doesn't work. It is using the following code and is a Crosstab query.

DoCmd.TransferText
acExportDelim, "ExportSpec_QryRMUNITS_Crosstab",
 

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

Top