locked
Exporting pass through query data RRS feed

  • Question

  • Hi

    When I try to export to text data from a pass through query like below I get the error 'Operation is not supported for this type of object.'

    DoCmd.TransferText acExportDelim, , "PassThroughSelect", "C:\Temp\Myfile.csv", True

    How can I get the pass-through query to work with text export?

    Thanks

    Regards

    Wednesday, July 6, 2016 10:45 AM

Answers

  • Hi Y a h y a,

    I had try to run the line of code mentioned by you in your post and its working on my side.

    I want to confirm with you that you had pass the "PassThroughSelect" as a source of data.

    so what is it? is it table or query or any other object?

    please try to run it separately and check data are available in that. also try to post it here.

    if it is any other object then I would recommend you to use table or query to export the data instead of that object. may be it is possible that it is not supported to export the data by this method.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, July 7, 2016 2:07 AM