Posted by Jonathan Roberts on 02/03/07 20:58
Wes Groleau 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.
>
Have you tried using the Upsize wizard?
Jonathan
[Back to original message]
|