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.
- RE: Data Export from Access to Excel
... I am able to get the query to run and load the data into the sheet I named ... Is it possible in the Excel sheet to say "in cell A2 I need the name of the ... spreadsheet that pulls information directly from the Access database. ...
- Re: DoCmd.TransferSpreadsheet: export from query to excel sheet through VBA
... I want to export data from a query to excel sheet using ... The starting cell should be 6 row and ending cell depends on the ... cells or the name of a range in the spreadsheet. ...
- Re: sql query for excel column values
... >> 50-1000 values in column A that I need to query an sql database ... >> spreadsheet name changes daily and the number of rows change daily. ... I'd like to program excel to ...
- Re: Linking an Excel worksheet to an Access table
... Once you got your query in Excel as I explained you ... parameter value from a certain cell. ... I would prefer to use Excel and have the spreadsheet get its ...
- RE: sql query for excel column values
... I only need to query if column AA has a value of "x". ... >> 50-1000 values in column A that I need to query an sql database for. ... >> spreadsheet name changes daily and the number of rows change daily. ... I'd like to program excel to start at cell ...