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

  • Thread starter Thread starter bomber
  • Start date Start date
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
 
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
Click to expand...
acExportDelim, "ExportSpec_QryRMUNITS_Crosstab",
 
Back
Top