Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql query for excel column values
I have a spreadsheet that I receive daily. there are about anywhere from
50-1000 values in column A that I need to query an sql database for. The spreadsheet name changes daily and the number of rows change daily. It's always column A (with a header). I'd like to program excel to start at cell A2, do the query, return the results to a new workbook, and continue down the list until the end. So far I've recorded the macro that sets up the database and returns a sample query, but I'm not sure how to go about the rest. I know the variables are the daily file, the number of rows in the dailyfile. How could I set it up so that it queries each cell value until the end of the data? Automation is the key here. I'm querying an MS SQL database. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic URL for first column of data from excel query? | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Excel query via ODBC cuts values | Excel Discussion (Misc queries) | |||
Excel formula, 2 colons query to sum values in colon 3 | Excel Programming | |||
Q) Last row/column ------ excel formula query | Excel Programming |