Transfer Data from MS Access to Excel

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.

Howdy, Stranger!

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

Categories