pull access data from excel

mtharnden

Board Regular
Joined
Aug 17, 2011
Messages
114
hello,
i have seen a few ways to do this but really need a dumbed down help

i have an excel macro that works of off data that we pull from an access database and the only part being done manually is editing the query and importing the data to excel

what i would like is something in excel VBA that pulls the data from access. my thought is in access i would have a basic query that has the fields we need and excel would have a form to filter those fields as needed
one of the fields is Date and another Location where we filter date ranges and locations. we currently go in to the query and filter the date range by hand and the locations we want by hand.

i am not that great in access so have not created any macros to pull the data from excel before so dont know what i am doing
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

RonB1111

Well-known Member
Joined
Nov 28, 2011
Messages
2,277
Excel has a built in function (ie: MS Query) to pull data from an external database such as MS Access and restrict records coming into Excel by the parameters you specify. VBA or macros are not needed. Here's a link explaining how to do this (assumes you have Excel 2007+):
http://www.utteraccess.com/wiki/index.php/Excel_MS_Query
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,376
Messages
5,836,896
Members
430,461
Latest member
flavgf

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