Exporting MS Access to SQL Server

hi,
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>