Hi,
I have a table in Microsoft Access 2007 that I want to be able to export directly into Microsoft Excel 2010. The table in access might vary in rows, but the columns will remain the same. I created a cmd button with this coding behind it:Private Sub cmdExport_Click()
Dim outputFileName As String
outputFileName = Me.Form.txtFile
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_PSAB_Asset_Roll_Up", outputFileName, True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_PSAB_Asset_Detailed", outputFileName, True
DoCmd.TransferSpreadsheet
End Sub
But this only appends two new tables into excel. I want to append one of the tables values into excel (the excel table has formula's that will further break up certain costs, this is for ease of the user).
Is this even possible?