Excel 2007 - How do I ...

bring data into an excel 2007 worksheet that is stored in a sql database table?

The idea is to parameterize the "where" clause in the sql select statement
limiting the result set.

There are lots of examples in the literature with regard to bringing in data
stored in cubes --- but not so much from data in sql table.

The basic issue is I want bring in descriptive information about say a
contract (things like description, signing date, etc). Cubes which most
(all) of the literature deals with are dealing with aggregations of amounts
or "measures" and not so much about descriptions.

As always all suggestions are welcome.

Mark

Tim
Thu May 08 23:50:45 CDT 2008

Google for "excel ado" - plenty of non-cube examples.
Eg:
http://scriptorium.serve-it.nl/view.php?sid=45

What type of "SQL database" ?

Tim


"Mark" <Mark@discussions.microsoft.com> wrote in message
news:8E8C11EB-D99D-4B1A-BDC6-84205DCE193D@microsoft.com...
> bring data into an excel 2007 worksheet that is stored in a sql database
> table?
>
> The idea is to parameterize the "where" clause in the sql select statement
> limiting the result set.
>
> There are lots of examples in the literature with regard to bringing in
> data
> stored in cubes --- but not so much from data in sql table.
>
> The basic issue is I want bring in descriptive information about say a
> contract (things like description, signing date, etc). Cubes which most
> (all) of the literature deals with are dealing with aggregations of
> amounts
> or "measures" and not so much about descriptions.
>
> As always all suggestions are welcome.
>
> Mark

Mark
Fri May 09 06:59:01 CDT 2008

Tim -

Thanks for the info --- guess I wasn't looking in the proper places.

Mark

"Tim Williams" wrote:

> Google for "excel ado" - plenty of non-cube examples.
> Eg:
> http://scriptorium.serve-it.nl/view.php?sid=45
>
> What type of "SQL database" ?
>
> Tim
>
>
> "Mark" <Mark@discussions.microsoft.com> wrote in message
> news:8E8C11EB-D99D-4B1A-BDC6-84205DCE193D@microsoft.com...
> > bring data into an excel 2007 worksheet that is stored in a sql database
> > table?
> >
> > The idea is to parameterize the "where" clause in the sql select statement
> > limiting the result set.
> >
> > There are lots of examples in the literature with regard to bringing in
> > data
> > stored in cubes --- but not so much from data in sql table.
> >
> > The basic issue is I want bring in descriptive information about say a
> > contract (things like description, signing date, etc). Cubes which most
> > (all) of the literature deals with are dealing with aggregations of
> > amounts
> > or "measures" and not so much about descriptions.
> >
> > As always all suggestions are welcome.
> >
> > Mark
>
>
>