B
BJ
I am having great difficulty in finding some help regarding the
TransferText method in Access 97. Essentially what I am trying to do
is run this piece of code in VBA:
DoCmd.TransferText acExportDelim, "Export To Crown",
"TBL_Utilities_Export_NewBoxes", "S:\QIS\Administrative
Services\Records Management\Export_NewBoxes.txt"
Unfortunately, I get the following error in the subject line of this
posting. I've updated by Office97 service pack to SR-2B as well as
installed the service pack for Jet3.5, but still have not been able to
get the results I want. I've even resorted to reinstalling Office 97
but that has failed as well.
The first step I do is to take the results of a parameter query and
append them to a table. Then I try to run the code above to export
the data from the table into a text file using an export specification
called "Export To Crown".
Any assistance in this matter would be greatly appreciated. Thank
you.
TransferText method in Access 97. Essentially what I am trying to do
is run this piece of code in VBA:
DoCmd.TransferText acExportDelim, "Export To Crown",
"TBL_Utilities_Export_NewBoxes", "S:\QIS\Administrative
Services\Records Management\Export_NewBoxes.txt"
Unfortunately, I get the following error in the subject line of this
posting. I've updated by Office97 service pack to SR-2B as well as
installed the service pack for Jet3.5, but still have not been able to
get the results I want. I've even resorted to reinstalling Office 97
but that has failed as well.
The first step I do is to take the results of a parameter query and
append them to a table. Then I try to run the code above to export
the data from the table into a text file using an export specification
called "Export To Crown".
Any assistance in this matter would be greatly appreciated. Thank
you.