471,337 Members | 1,165 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Excel 2007 Automation Question

What I want to do is 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
Jun 27 '08 #1
1 1077
It depends on where the excel worksheet resides. If it is on a sharepoint
server, you can do so easily. It sounds like it's not. If you have a cube,
you can tweak the MDX expression, it supports a where clause. Otherwise,
just use a filter in excel - it's functionally equivalent to a where clause.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------
"Mark" <Ma**@discussions.microsoft.comwrote in message
news:A1**********************************@microsof t.com...
What I want to do is 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
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Keith Wilby | last post: by
2 posts views Thread by rene.marxis | last post: by
15 posts views Thread by =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post: by
5 posts views Thread by Satish Itty | last post: by
2 posts views Thread by RP | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
13 posts views Thread by Peter | last post: by
9 posts views Thread by Peter | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.