ACCESS -> Excel

[Ragnar78]

Hy,
I was wandering if anyone can help with some beginners hint to start extracting in an ACCESS DB to EXCEL.

I already use the Pivotable function in ACCESS...but i was wandering if their is anyway to learn how to use macro sto calculate fields through ACCESS and then send them to EXCEL

Thank you,

 

[chad1222]

You can create a report with the data you want and then use the export to Word or Excel button at the top of the report. Then create some macros in your personal.xls that you could run and save the excel file as a new name . This has worked for me fine. Just have to get the report formatted so that the excel file comes out like you want it.
Chad
BTW i am using access and excel 2000, not sure if that feature is in 97

 

[Smitty]

Goto Data-->Get Extarnal Data-->New Database Query-->Microsoft Access. Follow the wizard from there to pull your Access Query info into Excel.

Once done, record a macro doing Data-->Refresh Dataa and you should be good to go.

Hope that helps,

Smitty