>Hi everybody!
>
>I am trying to transfer access database to SQL server.
>Using DTS I have trasfered all data. The main problem with queries.
>I have more than one hundred queries and I want to make a stored procedures at SQLServer side. Is there any way to do it programatticaly?
>Thanks.
I don't think that queries can be migrated. Did you check the "Microsoft Access Upsizing Tools 97"
http://www.microsoft.com/products/developer/officedeveloper/Access/ProdInfo/Aut97dat.htm
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com