Use VBA to export query to Excel file

[LaCour]

Is it possible to use VBA to export a query to an Excel file?

Is it possible to use VBA to update and existing Excel file?


Thanks
Blair

 

[glalsop]

Have a look at the TransferSpreadsheet method in Access help.

-Gary

 

[SkipVought]

Blair,

I usually prefer to set up a query IN EXCEL to Access that updates whenever the workbook opens. NO CODE REQUIRED.

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[sfreeman]

Question 1: Yes - code follows.
'------------------------------------------------------------
' ExportToExcel
'
'------------------------------------------------------------
Function ExportToExcel()
On Error GoTo ExportToExcel_Err

DoCmd.OutputTo acTable, "Table2", "MicrosoftExcelBiff8(*.xls)", "c:\test.xls", False, "", 0


ExportToExcel_Exit:
Exit Function

ExportToExcel_Err:
MsgBox Error$
Resume ExportToExcel_Exit

End Function

Question 2: Probably, but easiest way to manipulate excel data from access is to link to the spreadsheet as a linked table, then create update query or vba code to update.