MS paramater Query on ODBC Table

[Dean Southgate]

Is it possible to and if so how can I run a parameter driven MS query on an ODBC database table?

I want to be able to enter some info into a cell on a spreadsheet and have a query run to pull back other info relating to my entry.

 

[Tushar Mehta]

In MS Query, specify a condition in square brackets [ and ]

When tested in MS Query, you will be asked to provide a value.

When you return to XL, XL will give you three choices: (1) use a 'hard
coded' value, (2) provide the value each time, or (3) use the contents
of a specific cell. For the last option, you will also have a choice
to run the query automatically every time the cell contents change.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[PeterS]

Try the use of SQL in VBA.
Something like:

Sub GetData()
Myvar = [Sheet1!A1]

Select something
From somewhere
Where condition = Myvar
End Sub
--
PeterS

"Dean Southgate" <[email protected]> schreef in bericht
Is it possible to and if so how can I run a parameter driven MS query on an ODBC database table?

I want to be able to enter some info into a cell on a spreadsheet and have a query run to pull back
other info relating to my entry.