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

--
fbonnar
-----------------------------------------------------------------------
fbonnard's Profile: http://www.excelforum.com/member.php...fo&userid=1597
View this thread: http://www.excelforum.com/showthread.php?threadid=27446