Accessing via Excel

[Neo-fite]

I have an access 2007 database that has a handful of queries that are date range driven. Currently, I have to open the db and put the dates in a form...then the queries provide me the data for that data range.

Is it possible to use excel to connect to the access db and set those dates via a cell or variable in excel...therefore filling different tabs with the query data?

 

[apr pillai]

You can display specific Cell Values directly in a Textbox on a Form and use that Textbox reference as criteria in a query to filter data.

You can link an Excel Database as a Table in Access or open an Excel database directly after setting certain Property Value of Access Query.

Take a look at the following blog posts:

• Display Excel Values directly on Form
• Opening Excel Database directly
• Link External Tables Directly