S
Scott Elgram
Hello,
I'm hoping someone in here can help save me some time. I have an Access
DB that is huge......migrating the data to a SQL 7.0 server is not that big
of a problem but a lot of what this Access file does is with macros. One
macro in particular executes some 150+ queries. I want to move those
queries from Access and make them a series of stored procedures or
something. Right now I am opening the query in access, copying the sql view
and pasting it into SQL Query Analyzer, checking the syntax and making the
appropriate changes and then saving it. the problem is this takes way to
long and for 150+ queries it has become an extraordinarily tedious task.
Are there tools available to do what I need done or does anyone know an
easier way?
I'm hoping someone in here can help save me some time. I have an Access
DB that is huge......migrating the data to a SQL 7.0 server is not that big
of a problem but a lot of what this Access file does is with macros. One
macro in particular executes some 150+ queries. I want to move those
queries from Access and make them a series of stored procedures or
something. Right now I am opening the query in access, copying the sql view
and pasting it into SQL Query Analyzer, checking the syntax and making the
appropriate changes and then saving it. the problem is this takes way to
long and for 150+ queries it has become an extraordinarily tedious task.
Are there tools available to do what I need done or does anyone know an
easier way?