Export 2007 QRY to DBF

[fenhow]

Hi, I have a query in Access 2007. In 2003 I was able to use this code to export the query results into a DBF.

Private Sub Command61_Click()
Dim access As access.Application
Set access = CurrentProject.Application
access.DoCmd.OpenQuery "MASTER DBF QUERY"
access.DoCmd.TransferDatabase acExport, "dBASE IV", "c:\", acTable, "MASTER DBF QUERY", "MASTER.DBF"
DoCmd.Close acQuery, "MASTER DBF QUERY"
End Sub

Now in 2007 it no longer works. Does anyone have any suggestions?

Thanks.

Fen

 

[DCrake]

Why not use the Export data option from the ribbon and save the steps the the DoCmd.RunSavedImportExport function