Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Transfer Data from MS Access to Excel

greg_c.greg_c. Member Posts: 8
Hi

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:

Function Export()
Dim excel As String
excel = "CONSOLIDATION_XTRACT_TOTAL"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:Documents and SettingsGregoryChMy DocumentsTest.xls"


Greg

Sign In or Register to comment.