Results 1 to 1 of 1
2009-03-15, 17:48 #1
- Join Date
- Jan 2004
- Thanked 0 Times in 0 Posts
in this mdb are 2 table DATI and MERCATI.
i want to loop all values in PROVA2 from table DATI and matching in PROVA8 of table MERCATI return the related value of PROVA5 and insert in table DATI in PROVA21...
i just use this piece fo connection
Dim conConnection As New ADODB.Connection
Dim cmdCommand As New ADODB.Command
Dim rstRecordSet As New ADODB.Recordset
conConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\APPLICAZIONI\DB_PAST_DUE.MDB;Mode=Read|W rite"
conConnection.CursorLocation = adUseClient
in the mdb example are only a few list of records in real mdb have 985.478 records in PROVA2.