A
AS
Hi
I want to connect to SQL 2005 Contract Master table (CONTRACTMST) and Update
table using following Excel worksheet. I am new to VBA how to connect SQL and
update the table in SQL2005. Sample code will be highly appreciated regarding
the connection and update statement. Also How to copy all the rows to new
worksheet by city in the existing city.
contractid City Updatename
LCR0091 London Contract 1 new Name
LDW0091 London Contract 2 New Name
HMR0023 Hampshire Contract 3 New Name
HDE0029 Hampshire Contract 4 New Name
Thanks
I want to connect to SQL 2005 Contract Master table (CONTRACTMST) and Update
table using following Excel worksheet. I am new to VBA how to connect SQL and
update the table in SQL2005. Sample code will be highly appreciated regarding
the connection and update statement. Also How to copy all the rows to new
worksheet by city in the existing city.
contractid City Updatename
LCR0091 London Contract 1 new Name
LDW0091 London Contract 2 New Name
HMR0023 Hampshire Contract 3 New Name
HDE0029 Hampshire Contract 4 New Name
Thanks