Import Access data to SQL

I was using DTS to import some Access data to SQL Server 2000 and came
across some queries in Access that I thought would be converted into views .
There were around 50 queries in Access and just 3 of them showed up in the
DTS Wizard and that too they turned out to be tables on SQL Server. I was
hoping that maybe these select queries may turn into view or built as stored
procedure.
Is that not the case ? If so, do I have to manually create them.
Thanks
Most likely, (IMO, it is preferred), you need to manually recreate those
queries in Access as most suitable SQL Server object, views, SPs or UDFs,
not only due to the differences of the SQL syntex, but also due to the
different functionalities Access and SQL Server provide.
"Hassan" <hassan@.hotmail.com> wrote in message
news:uu2xhi8yHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I was using DTS to import some Access data to SQL Server 2000 and came
>across some queries in Access that I thought would be converted into views
>.
> There were around 50 queries in Access and just 3 of them showed up in the
> DTS Wizard and that too they turned out to be tables on SQL Server. I was
> hoping that maybe these select queries may turn into view or built as
> stored procedure.
> Is that not the case ? If so, do I have to manually create them.
> Thanks
>