Why when I import Access 2000 queries into SQL Server they
come over as tables? The DTS shows the glasses stating
that it is a view, yet when I import the query, it gets
imported as a table. I have admin rights, so I don't know
what the problem is. Can someone please help me.

Thanks,
Chris

In message <26c3201c46371$99c11a40$a601280a (AT) phx (DOT) gbl>, Chris
<celias (AT) professionalbenefits (DOT) net> writes
DTS is for importing data, not upgrading Access to SQL Server, so it
just thinks you want that data imported, so it copies it across and of
course requires a table to put it in.

Maybe you should look at the Access to SQL up-sizing wizard, I forget
the exact name.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org