Transfer Data from MS Access to Excel


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
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:Documents and SettingsGregoryChMy DocumentsTest.xls"


Sign In or Register to comment.

Howdy, Stranger!

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