PDA

View Full Version : data model in excel



suhasmahajan
02-02-2011, 02:21 AM
Hi, I need help in excel vba macro.

refer attached excel

I am creating excel based tool for data modelling. which will connect to database e.g oracle, sql server and then fetch the table information.

e.g table name- emp then its all column . till this I have achieved it. now m getting all tables with its column name , primary key...

Now my question is with the help of above data I want to preint table in excel and want to show relationship between them PK FK by drawing a line between them.
e.g
EMPLOYEE DEPT
eno (pk) dno (pk)
ename eno (fk)
eaddrs dname


now it should show in well tabular form in excel and should draw line between employee.eno to departnment.eno.
can we do it with help of macro.


regards,
Suhas

IBihy
02-09-2011, 04:16 PM
Hello,

Wow, interesting question, but isn't that the realm of MS Access rather than MS Excel? Are you aware of the scope of this question?

Not meaning to be unfriendly, but I think the effort on this one, calculating USD 40 per hour, which is a reasonable price for a subcontractor, exceeds the license fee for MS Access, by far.

Regards,
Isabella

slamet Harto
02-11-2011, 01:02 AM
what about using

Data > Get External Data > From Microsoft Query

shrivallabha
02-12-2011, 12:33 AM
Take a look at the code provided by XLD. Pray that he comes around...
http://www.vbaexpress.com/forum/showthread.php?t=35298

Bob Phillips
02-12-2011, 06:11 AM
How about using Visio, it has such a function it its Enterprise version.