Linking Access Database data to Excel Spreadsheet?

[Guest]

I'm trying to setup an Excel Spreadsheet that pulls information from an
Access DB.

Imagine a table in Access that has multiple rows based on individual stores
(e.g. Store A, B, and C).

Next Imagine an Excel Spreadsheet that users will open (the spreadsheet has
prepopulated formulas) and then the user can filter on the Store that they
want to look at (e.g. I want to only look at Store A). The users will only
want to look at one Store per Spreadsheet.

I am trying to find out how to:

(1) connect the Access Table to my Excel Spreadsheet so that the cells can
pull info and be populated by clicking some type of "download info" button or
command

(2) filter the pulling of the information from Access to the Excel
Spreadsheet by a specific Store

Thank,
jm

 

[Guest]

This should be done through Excel. You can create MS queries in Excel that
will pull data from the Access tables or Queries.

 

[Guest]

Okay. I'm in Excel. The data is in an Access Database Table.

I want to be able to populate the Excel Spreadsheet with the Access Table
Information, and be able to filter on a specific characteristics (e.g. say
one of the Table's columns is "Store Name" and has three store's A, B, and
C).

I want to open up Excel, then select a Store, for example Store A, and then
refresh the data to get all the information on Store A that lives in the
Access Database Table to populate my Excel Spreadsheet.

 

[Guest]

You can do that. From your Excel meny Data->Import External Data->New
Database Query

 

[Guest]

I see how to link the information. But I'm not finding a good way to filter
the information I pull into my Excel Spreadsheet.

Before I pull the Access Database Information into my Excel, I want to
filter it by Store, which is one of the columns in the my Access Table.

I would prefer to be able to put the Store in cell A1 of my Sheet1 (e.g. A),
and then have the all my information filtered that I'm pulling from Access
Table to reference cell A1.

This way, a user could just put in cell A1 the Store they want to look at,
and then only get the information that relates to that Store designated in
cell A1.

does this make sense?

 

[Guest]

This will require modifying the query at run time. I am probably not the
very best at that, so I am not sure I can help with the best way to do that.
Perhaps you should post in an Excel group.