Several sql queries with the same recordset

[fbonnard]

When you said

set Cnn=New ADODB.Connection
Cnn.Open Cn
Cnn.Execute sql ' your SQLS starting UPDATE (does not return a recor
set)
Cnn.Execute sql ' your SQLS starting INSERT (does not return a recor
set)


What is cn ?

How can i use RecordCount and CopyFromRecordset if i need to make
select

 

[Guest]

Refer to the Excel VBA help file for information on CopyFomRecordSet.

 

[Guest]

Refer to the code in your original query .... relevant part pasted here (see
line 2):

If (Range("B" & i).Value > 0) Then
rs.Open mySql4, cn, adOpenStatic
rs.Close
Else
rs.NextRecordset mySql3, cn, adOpenStatic
rs.Close
End If

cn in this context is either an ADODB.Connection object that has been opened
or it is simply a string that can be used to connect to the databas,
something like:

cn="DSN=your DSN;UID=your userid;PWD=your password"