I'm not sure you can use Jet to transfer between SQL 7 and SQL 2000.
AFAIK,
SQL Server doesn't use Jet.
Not exactly true - The Jet engine is somehow one of the
things SQL Server understands, if that feature is turned
on. Part of the reason Jet is no longer distributed with
MDAC was that Jet provided a security hole that allowed
users to delete arbitrary files (etc) from the Server
hosting your SQL server.
That particular problem was fixed by changes to Jet, but
the more general decision was reached that SQL Server
should not install Jet by default.
(david)