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
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

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:

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,917
Members
414,416
Latest member
Nobu

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