Access To Sql Server Conversion

The Points To be Noted While Converting To Access Software and Queries to Sql
1) First Of all change the Provider name By changing the Provider Seeing to Sql Provider
2) Now check for connectivity
3) Then import the tables
a. Right click on the data base
b. Select all task -> import database
c. Select the source and destination
d. Now import the tables
4) now there are some modification on the queries
a. the date format the sql Most support is “MMM dd/yyyy”
b. so convert the dates
c. now u can see that mostly we use # symbol in the Access Queries
d. so Replace that with ‘ (single quotes)
e. and it may use the iif() statement in access Queries
f. instead of that we have to use Case ( WHILE condition then ‘output’ ELSE statements end ) as name

5) In vb projects instead on using record set to insert we can use the Provider. Execute Statement Like Execute Statement “ insert in to …”
6) in access we use the "ucase " But in Sql we use Upper
7)in access we use the "Lcase " But in Sql we use Lower
8) in access we can use delete * from table name But In Sql We use just 'Delete From tablename
For further Queries please mail me on antorubin@gmail.com