Hello.

I have a problem with transfering data from MSSQL Server 2005 to Access.

I need to make a VBScript that can take out all data from one table in mssql and update one table in Access.

The tables exist in both databases and looks the same, but there can be more information in the table from MSSQL Server so i will need to update the table in Access with this information.

E.g.
I have a table called: SMP_Alert in both database's. So what i want to do something like this (dunno if that is possiable):

Set objConMSSQL = CreateObject("ADODB.Connection")

conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1\SMP;Database=SM P;Uid=SA; Pwd=smp;"

objConMSSQL.Open(conMSSQL)

strSQL = "SELECT * INTO
[Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SMP\DB\SMP.mdb;Persist Security Info=False].[SMP_ALERT]
FROM
[Provider=SQLNCLI;Server=127.0.0.1\PMS;Database=SMP ;Uid=SA; Pwd=smp;].[smp.dbo.SMP_Alert];"

objConnectionMSSQL.Execute(strSQL)

objConnectionMSSQL.Close


Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the information into the table in Access?
If so how would that look like?