Posted by Wes Groleau on 02/05/07 05:07

Steve wrote:
> 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

No. That's SQL Server 2005. Thanks anyway.

--
Wes Groleau

In any formula, constants (especially those obtained
from handbooks) are to be treated as variables.

[Back to original message]