Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access-SQLServer (Access queries)
Message
 
To
29/03/2000 12:27:57
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00352200
Message ID:
00352210
Views:
8
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform