sql数据库连接问题

下面的红色代码是 sw.mdb数据库的连接代码,因要转为SQL数据库,不知怎么连接,

SQL数据库用户名 "ta" 
SQL数据库用户密码 "yaad3333"  
SQL数据库名"#SW" 
SQL服务器名 SOURCE=PC-201110101711\SQLEXPRESS;  
有会修改的帮忙下,谢谢

<!--#include file="Start.asp"--> 
   
  <% 
  Dim clpp, clsl, czxm, Mail, Tel, Content, adress, addtime, wt1,wt2,wt3,wt4,wt5,wt6,wt7,wt8,wt9,wt10, exec 
set conn=server.createobject("adodb.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.open=server.mappath("/Database/sw.mdb")



clpp=request.form("clpp") 
clsl=request.form("clsl") 
czxm=request.form("czxm")
Mail = request.Form("Mail")
Tel=request.form("Tel")
Content=request.form("Content")
adress=request.form("adress")
Addtime=request.form("now()")
wt1=request.form("wt1")
wt2=request.form("wt2")
wt3=request.form("wt3")
wt4=request.form("wt4")
wt5=request.form("wt5")
wt6=request.form("wt6")
wt7=request.form("wt7")
wt8=request.form("wt8")
wt9=request.form("wt9")
wt10=request.form("wt10")

If len(clpp) < 2 Then
response.write "<script>alert(""请输入车辆品牌!"");history.back(-1);</script>"
response.end
End If
If len(clsl) < 1 Then
response.write "<script>alert(""请输入车量数量!"");history.back(-1);</script>"
response.end
End If
If len(czxm) < 2 Then
response.write "<script>alert(""请输入车主姓名!"");history.back(-1);</script>"
response.end
 End If
If len(Tel) < 8 Then
response.write "<script>alert(""请正确输入电话号码!"");history.back(-1);</script>"
response.end
 End If
If len(adress) < 2 Then
response.write "<script>alert(""请输入联系地址!"");history.back(-1);</script>"
response.end
End If
exec="insert into PE_Zxbm(clpp,clsl,czxm,Mail,Tel,Content,adress,wt1,wt2,wt3,wt4,wt5,wt6,wt7,wt8,wt9,wt10,addtime)values('"+clpp+"','"+clsl+"','"+czxm+"','"+Mail+"','"+Tel+"','"+Content+"','"+adress+"','"+wt1+"','"+wt2+"','"+wt3+"','"+wt4+"','"+wt5+"','"+wt6+"','"+wt7+"','"+wt8+"','"+wt9+"','"+wt10+"',now())"
conn.execute exec
conn.close
set conn=nothing
response.write "<script>alert(""报名成功!"");location.replace('index.html');</script>"
 %>

直接在sql 里用导入导出功能转.

http://blog.csdn.net/fredrickhu/article/details/4961799

可以在原来的代码修改下?文章那些代码始终不太一样,用了都有点错