data model in excel

Hi, I need help in excel vba macro.

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

Thank You This will be helpfull for me... need to check..