data model in excel

[suhasmahajan]

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]

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]

what about using

Data > Get External Data > From Microsoft Query

[shrivallabha]

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]

How about using Visio, it has such a function it its Enterprise version.