ACCESS -> Excel

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
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,
(y)
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

chad1222

Board Regular
Joined
Jul 14, 2003
Messages
133
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

Legend
Joined
May 15, 2003
Messages
29,536
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,382
Messages
5,595,853
Members
414,027
Latest member
zippyfrog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top