|
Home > Archive > MS SQL Server Reporting Services > August 2005 > How I can obtain the data from files Exel, throw ODBC provider?
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 |
How I can obtain the data from files Exel, throw ODBC provider?
|
|
| Sergey Fedorenko 2005-08-30, 11:25 am |
| What will be "Query string"?
Thank
| |
| Chris Baldwin 2005-08-30, 11:25 am |
| Hello Sergey,
> What will be "Query string"?
>
> Thank
>
The query string will be like a typical SQL Select statement, except instead
of a table name you specify a named range from which the data should be drawn.
If you have a grid in an Excel sheet that looks like this:
ID FirstName LastName
1 George Washington
2 John Adams
3 Thomas Jefferson
And you define those cells as named range "Presidents", then:
SELECT ID, FirstName, LastName FROM [Presidents]
Here's some more info on ODBC/Excel. It targets ASP developers, but some
of the facts here may apply to you:
http://support.microsoft.com/kb/q195951/
-Chris
|
|
|
|
|