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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

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,128,088
Messages
5,628,603
Members
416,327
Latest member
Chimay

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