You cannot import the relationships from Access using DTS. There is an
Access upsizing tool ( http://support.microsoft.com/?kbid=237980 ) which may
be what you want here.
--
Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
"Roger Svensson" <roger.svensson (AT) fyrklovern (DOT) se> wrote
Quote:
I've made a DTS package in SQL server 2000 to import tables and data from
an
Access 2000 database. Everything works fine except for one thing: The
table
relationships aren't there...does anyone know why and how I should do it
instead?
/Roger
|
Table relationships from Access database? -
08-15-2006
, 07:05 AM
Linear Mode
