Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values in Excel as parameters in Microsoft Query connection
I currently have an Excel sheet containing data, and I'd like to create a SQL
query where parameters in my query are fields in my Excel sheet. I know how to create a SQL query or other data connection, but I don't know how to include my Excel data as a datasource in the query. Is this possible, and, if so, how would I do it? Thanks in advance, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values in Excel as parameters in Microsoft Query connection
Dan,
You can do this by using the importing external data query: 1) Go to data, import external data, new database query 2) Select or browse to the database you wish to connect to 3) Click cancel in the next screen and Click yes to open the macro Query editor 4) Create your query and add filters to it 5) In the filter list enter "[Your description]" 6) Return the data to excel 7) Click on the Parameter button and select the cell where your criteria houses. Regards, Brotha lee "Dan" wrote: I currently have an Excel sheet containing data, and I'd like to create a SQL query where parameters in my query are fields in my Excel sheet. I know how to create a SQL query or other data connection, but I don't know how to include my Excel data as a datasource in the query. Is this possible, and, if so, how would I do it? Thanks in advance, Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values in Excel as parameters in Microsoft Query connect
Sorry; I should have mentioned that I'm using Excel 2007. I know that you can
filter your results in 2007, as you mention below, but don't remember how & have had no luck using Excel Help. "Brotha Lee" wrote: Dan, You can do this by using the importing external data query: 1) Go to data, import external data, new database query 2) Select or browse to the database you wish to connect to 3) Click cancel in the next screen and Click yes to open the macro Query editor 4) Create your query and add filters to it 5) In the filter list enter "[Your description]" 6) Return the data to excel 7) Click on the Parameter button and select the cell where your criteria houses. Regards, Brotha lee "Dan" wrote: I currently have an Excel sheet containing data, and I'd like to create a SQL query where parameters in my query are fields in my Excel sheet. I know how to create a SQL query or other data connection, but I don't know how to include my Excel data as a datasource in the query. Is this possible, and, if so, how would I do it? Thanks in advance, Dan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values in Excel as parameters in Microsoft Query connect
Never mind...just figured it out. Thanks for the help.
"Dan" wrote: Sorry; I should have mentioned that I'm using Excel 2007. I know that you can filter your results in 2007, as you mention below, but don't remember how & have had no luck using Excel Help. "Brotha Lee" wrote: Dan, You can do this by using the importing external data query: 1) Go to data, import external data, new database query 2) Select or browse to the database you wish to connect to 3) Click cancel in the next screen and Click yes to open the macro Query editor 4) Create your query and add filters to it 5) In the filter list enter "[Your description]" 6) Return the data to excel 7) Click on the Parameter button and select the cell where your criteria houses. Regards, Brotha lee "Dan" wrote: I currently have an Excel sheet containing data, and I'd like to create a SQL query where parameters in my query are fields in my Excel sheet. I know how to create a SQL query or other data connection, but I don't know how to include my Excel data as a datasource in the query. Is this possible, and, if so, how would I do it? Thanks in advance, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to store a connection with parameters into a workbook | Excel Discussion (Misc queries) | |||
Excel Query Parameters | Excel Discussion (Misc queries) | |||
Microsoft Query - pull data from Access "Too many parameters" | Excel Programming | |||
Run an Access Query from Excel VBA with Parameters | Excel Programming | |||
Microsoft query won't allow parameters | Excel Programming |