for the love of excel - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

for the love of excel

Author

Topic

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-01-19 : 16:10:11

This title cracked me up:

Manage Database Metadata with POI and Excel

My boss who knows nothing about database design, but likes excel will probably love it though.
I cant wait to export INFORMATION_SCHEMA views to excel, I am sure it will make my life a lot easier

Quote from the article:

quote:
"While a certain amount of discipline is required to keep these worksheets up to date, the utility will allow you to begin improving your database housekeeping"

rockmoose

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-19 : 16:34:54

Why export it?

Just connect to it in Excel VBA

Or better..use an ADP

Or you can have some fun like we're having

http://www.dbforums.com/t1093938.html

Brett

8-)

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-01-19 : 16:51:42

funny indeed !

-------------------------------------------------------------------------------
We have this really cool app that imports the metadata,
AND generates and RUNS the necessary DDL statements to make the database compliant
with the NEW metadata specifications.

The only thing is that it is a bit SLOW when there is alot of data in the tables.

Do You think that if I used XML, it would make it faster ?

rockmoose

jhermiz

3564 Posts

Posted - 2005-01-19 : 19:40:58

The germans love excel they call it the daaaaaaaaaatabase here.

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-19 : 21:05:59

http://neopoleon.com/blog/posts/434.aspx

Who has seen one of these meetings taking place ?

/raises hand solemnly

Damian

nr
SQLTeam MVY

12543 Posts

Posted - 2005-01-19 : 21:12:52

Interviewer: Have you used any database design tools
Interviewee: Yes, Excel

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Kristen
Test

22859 Posts

Posted - 2005-01-20 : 01:32:19

"Do You think that if I used XML, it would make it faster ?"

No, but it will be n-tier

Kristen

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-01-20 : 01:50:22

quote:
Originally posted by Merkin

http://neopoleon.com/blog/posts/434.aspx

Who has seen one of these meetings taking place ?

/raises hand solemnly

Damian

that guy is really artistic, liked his drawings, very expressive.

atleast the marketing group learned from previous experience and they're pretty good at brainstorming noh?

LOL

--------------------
keeping it simple...

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-01-20 : 03:03:06

One of my favourites is when we were given excel sheets to import into our dw system.
And they used color coding to distinguish the data "#¤!"#¤!!

DTS doesn't do that Yet!
Maybe I should put it on my wishlist to m$

rockmoose

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-01-25 : 06:41:01

Merkin, that link is brilliant

steve

And how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources