I'm hoping that someone can help me on this problem. Here's what I have to do.

I have a large access database with approximately 1 Million rows. I need to have a user select certain criteria in an Excel workbook, then depending on that selection, choose a certain table from an Access database. Or, even better, take their selection, intellegently update the access query, then export the data back to Excel. I think I've figured out how to use the TransferSpreadsheet method from Access, however, how do I go about getting variables defined in Excel to be read in access. Is that even possible?

Here's an example

In Excel:

Select a state, for example: State = Michigan

In Acess

Look up a certain table, run a statement that says, "only give me michagan results" and then export that Michigan data back to Excel.

Can anyone help? I want to make this automated as possible.