Export Query to Desktop

[techkenny1]

Hi,

I have a requirement to export an access query to the desktop where MYOB can link via software.

I have created a command button on a form with this code

Private Sub PostInvoices_Click()
On Error GoTo Err_PostInvoices_Click

    Dim stDocName As String

    stDocName = "QSendInvoices"
    DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_PostInvoices_Click:
    Exit Sub

Err_PostInvoices_Click:
    MsgBox Err.Description
    Resume Exit_PostInvoices_Click
    
End Sub

How can I change this code to export this query to the desktop.

Many thanks,

kp

 

[dhookom]

How far did you get in Help?
Did you decide you need to determine the export format?


Duane
Hook'D on Access
MS Access MVP

 

[bubba100]

You do not need to open the query. In the help review: Docmd.OutputTo acOutputQuery.