Import to Excel from Access table based on parameters

[rebubula]

Hi All-

I am attempting to create a template that will utilize data from an Access table, and allow the user to select the parameters in the Excel file. The amount of records in this table is slowing down the Excel file, and I would like to lessen the amount of data that is imported based on the user selection.

The Access table will have three columns:
Part Number|Line|Catalog Code

I would like to import all three columns, but allow the user to select the records imported based on the catalog code.

The users do not have read or write access to the sql tables, so I run an Access query at the end of each day to create an Access table that they can access.

I have 2007 versions. Is this type of import possible?

Thanks in advance!

 

[Flank]

I am also trying to create a simliar type function.

Where I have a drop down box that list the specific table in Access I want to use giving it's output to Cell A2

I then have a From Date Listed in B2 and a To Date listed in cell C3.

I think we are both trying to create essentially the same thing, but I have not found a related something similar yet.