Hi;
I m new in VBA, can anyone tell me is it possible to use VBA to
update data to a database?
I m actually using a string like below to connect to my db:
Let DSN = Sheets("Settings").Range("B7").Value
strConn = "OLEDB;Provider=MSDASQL.1;Persist Security
Info=False;User ID=ABC;Password=password;Data Source='" & DSN & "'"
if i have a query:
StrSQL = "update table set field1='123' where id = 'abc'"
may i know how to code so that i could execute this StrSQL?
Thanks for your help :)
Doris
--
doristsr
------------------------------------------------------------------------
doristsr's Profile:
http://www.excelforum.com/member.php...o&userid=35881
View this thread:
http://www.excelforum.com/showthread...hreadid=558721