I'm trying to transfer Data from MS Access to MS Excel and open it up with a pivot table. Would anyone have any ideas on how to go about doing this. Here is my code thus far:
Dim excel As String
excel = "CONSOLIDATION_XTRACT_TOTAL"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:Documents and SettingsGregoryChMy DocumentsTest.xls"