Using DTS To Migrate Access Ot SQL Server

When I try to import from Access, the DTS wizard only allows me to
import tables and queries. OK, I'm not surprised the "macros" and
reports don't come over.

But it executes each query, and created a _table_ to hold the results.

The sensible thing would be that SELECT queries become views
and the others become stored procedures. But I find no way
controls I can select to do that.

I have to manually create the views/procedures and paste in the SQL.
And then I still have to translate it into standard SQL.

--
Wes Groleau

Beware of the man who works hard to learn something, learns
it, and finds himself no wiser than before ... He is full of
murderous resentment of people who are ignorant without having
come by their ignorance the hard way.
-- Kurt Vonnegut