However, I'm trying to create a vb Script, which uses the exisitng odbc DSN connection and import or read a table and save that table in my network path as MS ACCESS .mdb format:
Expand|Select|Wrap|Line Numbers
- Set MyConn = Server.CreateObject("ADODB.Connection")
- MdbFilePath = Server.MapPath("abc")
- MyConn.Open "Driver={xyz 32bit Driver };
- DBQ=" & MdbFilePath & ";"
- SQL_query = "SELECT * from table1"
- Set RS = MyConn.Execute(SQL_query)
- WHILE NOT RS.EOF
- RS.MoveNext
- WEND
- RS.Close
- set RS = nothing
- MyConn.close
- set MyConn = nothing