While importing from ms access to sql server 7.0 table
relationships are not coming in sql server, but table data
are imported properly. how to get the relationships of
those tables. help me.

You cannot using DTS.

You can either

1. Create the scripts manually
2. Some have managed to reengineer the CREATE INDEX statements from the
Access database using DAO
3. Use the Access upsizing wizard.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"lakshminarasimhan" <rlnarasimhan (AT) rediffmail (DOT) com> wrote