All, Using Sql Server 2008 backend w/Access 2003 front end. I am running this code using pass thru qry.
Private Sub Command10_Click()
On Error GoTo Err_Command10_Click
Dim stDocName As String
stDocName = "qrySPReports_test_passthru"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.OutputTo acOutputTable, "qrySPReports_test_passthru", acFormatXLSX
I want this to output to excel 2010 on the users desktop. I am getting the error" property not found". It runs the query and it opens in datasheet but doesn't save to the desktop or folder as expected. The datasheet does not close. Can anyone tell me what's wrong with my code please. Thank you
Access 2003 does not recognize the format acFormatXLSX (2010). Also, it cannot save it in the 2010 format. MS Office is not forward-compatible. It is backward-compatible, however, so you can save it in XLS format, have the user open it in Excel 2010, and re-save it.
Last edited by Sam Landy; 07-19-12 at 10:24.
Reason: fixed typo