Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a query based off values in col A
I have a macro that pulls data from an extranal websit.
The values return look like this 861 913 315 407 570 These are area code Based off the value I need to query our database via ODBC Select Count(*) from Table where Telephone is like value in A1 Select Count(*) from Table where Telephone is like value in A2 Select Count(*) from Table where Telephone is like value in A3 Select Count(*) from Table where Telephone is like value in A4 etc I only need to see the count return to Column B Any ideas on how to proceed Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a query based off values in col A
"sjones" wrote ...
Based off the value I need to query our database via ODBC Select Count(*) from Table where Telephone is like value in A1 Select Count(*) from Table where Telephone is like value in A2 Select Count(*) from Table where Telephone is like value in A3 Select Count(*) from Table where Telephone is like value in A4 etc I only need to see the count return to Column B Any ideas on how to proceed Some ideas: SQL.REQUEST if you like ready-tolled worksheet formulas and many round trips to the database isn't an issue (the formula can point to the value in the cells). MS Query if you prefer a GUI data access tool (the cell values can be passed as parameters). ADO if you like VBA code (you can do just about anything you like with VBA!) Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on Running Query | Excel Discussion (Misc queries) | |||
Running Query | Excel Worksheet Functions | |||
Running a saved query | Excel Programming | |||
running a Database Query | Excel Programming | |||
Running Query on a record set | Excel Programming |