Posted by Steve on 02/04/07 07:24

On Feb 3, 12:24 pm, Wes Groleau <groleau+n...@freeshell.org> wrote:
> 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

Did you try the SQL Server Migration Assistant for Access?
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

[Back to original message]