xl SS to query an Access database query
 

Hi,

I want the user to give a "start" and "end" date on an xl SS, then query an
Access DB for specific data. I've created another Access database that does
a link-query (is that correct name?) to the 'Main' database, but would rather
go the Excel SS route since this is where the report is created.

Is it possible to make a Vis. Basic code that will just query the "Main"
database for this data, and create a worksheet for this?

Each report is saved as a separate Excel file.

thanks!

matt

xl SS to query an Access database query
 

Give this a look on Ron's site...

http://www.rondebruin.nl/accessexcel.htm
--
HTH...

Jim Thomlinson


"Matt" wrote:

Hi,

I want the user to give a "start" and "end" date on an xl SS, then query an
Access DB for specific data. I've created another Access database that does
a link-query (is that correct name?) to the 'Main' database, but would rather
go the Excel SS route since this is where the report is created.

Is it possible to make a Vis. Basic code that will just query the "Main"
database for this data, and create a worksheet for this?

Each report is saved as a separate Excel file.

thanks!

matt

xl SS to query an Access database query
 

Thanks Jim, this really helps!
matt

"Jim Thomlinson" wrote:

Give this a look on Ron's site...

http://www.rondebruin.nl/accessexcel.htm
--
HTH...

Jim Thomlinson


"Matt" wrote:

Hi,

I want the user to give a "start" and "end" date on an xl SS, then query an
Access DB for specific data. I've created another Access database that does
a link-query (is that correct name?) to the 'Main' database, but would rather
go the Excel SS route since this is where the report is created.

Is it possible to make a Vis. Basic code that will just query the "Main"
database for this data, and create a worksheet for this?

Each report is saved as a separate Excel file.

thanks!

matt