pull access data from excel

[mtharnden]

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

 

[RonB1111]

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