Home > Archive > SQL Server Programming > January 2006 > Query from within Excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Query from within Excel
|
|
| Preacher Man 2006-01-30, 7:06 pm |
| I have a need for some query help and I will try to explain my situation.
Thanks in advance for any help.
I have an Excel spreadsheet that has two different sheets. One one sheet
called "Data" I have created a query that pulls AP Invoices from from a SQL
database. In the results of this query I may have several lines with the
same Company.
Ok here's my question. On my other sheet page of the same file, is there
any way to run a Select statement and use the "Data" sheet as the FROM
Source?
I know this is very confusing, I just hope someone can decipher what I have
written.
| |
| Mubashir Khan 2006-01-31, 7:09 pm |
| you can do it directly via vba. No need to access via oledb.
"Preacher Man" <nospam> wrote in message
news:O6zqUCfJGHA.1424@TK2MSFTNGP12.phx.gbl...
>I have a need for some query help and I will try to explain my situation.
>Thanks in advance for any help.
>
> I have an Excel spreadsheet that has two different sheets. One one sheet
> called "Data" I have created a query that pulls AP Invoices from from a
> SQL database. In the results of this query I may have several lines with
> the same Company.
>
> Ok here's my question. On my other sheet page of the same file, is there
> any way to run a Select statement and use the "Data" sheet as the FROM
> Source?
>
> I know this is very confusing, I just hope someone can decipher what I
> have written.
>
|
|
|
|
|