Export table to Excel (Acc 2K)

Topic

New Reply

Greetings,

I

Reply | Quote

Replies

You can use DoCmd.TransferSpreadsheet in the On Click code of a command button to export a table or query to Excel. For example:

Private Sub cmdExport_Click()
DoCmd.TransferSpreadsheet TransferType:=acExport, _
SpreadsheetType:=acSpreadsheetTypeExcel9, _
TableName:=”Name_of_Table_or_Query”, _
FileName:=”C:ExcelExport.xls”, _
HasFieldNames:=True
End Sub

Reply | Quote

You can use DoCmd.TransferSpreadsheet in the On Click code of a command button to export a table or query to Excel. For example:

Private Sub cmdExport_Click()
DoCmd.TransferSpreadsheet TransferType:=acExport, _
SpreadsheetType:=acSpreadsheetTypeExcel9, _
TableName:=”Name_of_Table_or_Query”, _
FileName:=”C:ExcelExport.xls”, _
HasFieldNames:=True
End Sub

Reply | Quote