Visual FoxPro SQL Queries - 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, 8:25 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.

Sponsored Links