pass parameter to access query

  • Thread starter Thread starter souris
  • Start date Start date
S

souris

I have a external database to link MS Access Query.
I can run the query from Excel, but I need pass the start date and end date
to the query.

Are there any way to pass MS Access Query parameter from Excel Spreadsheet?

Any information is great appreciated.

Inung
 
In two cells on the worksheet, type the start date and the end date

Select a cell in the extract range
Choose Data>Import External Data>Edit Query
Click the Cancel button, and click Yes to edit in MS Query
In MS Query, choose View>Criteria
Select a criteria field, and in the cell below, type
a prompt, inside square brackets, e.g.
Between [start] And [end]
Choose File>Return Data to Microsoft Excel
Enter the criteria when prompted, and click OK

In Excel, select a cell in the extract range
Choose Data>Import External Data>Parameters
Select one of the criteria in the list
Select 'Get the value from the following cell'
Select the cell with the criteria, and check
'Refresh automatically', if required
Repeat for the other criteria
Click OK
 
Thanks for responding.

My Edit Query is disable.

Do you know how can I enable the Edit Query?

Thanks again,

Inung

Debra Dalgleish said:
In two cells on the worksheet, type the start date and the end date

Select a cell in the extract range
Choose Data>Import External Data>Edit Query
Click the Cancel button, and click Yes to edit in MS Query
In MS Query, choose View>Criteria
Select a criteria field, and in the cell below, type
a prompt, inside square brackets, e.g.
Between [start] And [end]
Choose File>Return Data to Microsoft Excel
Enter the criteria when prompted, and click OK

In Excel, select a cell in the extract range
Choose Data>Import External Data>Parameters
Select one of the criteria in the list
Select 'Get the value from the following cell'
Select the cell with the criteria, and check
'Refresh automatically', if required
Repeat for the other criteria
Click OK

I have a external database to link MS Access Query.
I can run the query from Excel, but I need pass the start date and end
date to the query.

Are there any way to pass MS Access Query parameter from Excel
Spreadsheet?

Any information is great appreciated.
Click to expand...
Click to expand...
 
Edit Query is an option feature of Excel.
I do not have this feature on my Excel.
Are there any other solution or how can I get this feature.
Thanks in advance,

Inung


souris said:
Thanks for responding.

My Edit Query is disable.

Do you know how can I enable the Edit Query?

Thanks again,

Inung

Debra Dalgleish said:
In two cells on the worksheet, type the start date and the end date

Select a cell in the extract range
Choose Data>Import External Data>Edit Query
Click the Cancel button, and click Yes to edit in MS Query
In MS Query, choose View>Criteria
Select a criteria field, and in the cell below, type
a prompt, inside square brackets, e.g.
Between [start] And [end]
Choose File>Return Data to Microsoft Excel
Enter the criteria when prompted, and click OK

In Excel, select a cell in the extract range
Choose Data>Import External Data>Parameters
Select one of the criteria in the list
Select 'Get the value from the following cell'
Select the cell with the criteria, and check
'Refresh automatically', if required
Repeat for the other criteria
Click OK

I have a external database to link MS Access Query.
I can run the query from Excel, but I need pass the start date and end
date to the query.

Are there any way to pass MS Access Query parameter from Excel
Spreadsheet?

Any information is great appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top