Hey everyone.

I know how to import data from access using excel but I have lots of data in this database. I want to be able to import specific data that I am looking for.

I have a file name Store.DB. In it are all the stores I am working with (ie 101, 102, etc). I want to be able to pull a specific store number and all the data that goes with that store from that database.

I want to be able to enter the store number I am looking to pull into a field somewhere on the excel sheet that will designate which store number to pull. This way I can change it for future stores. I think I have to create a macro for this and would love some help in doing so.