Update sql server using excel

[davecarrera]

Hi All,

Sorry if this is in the wrong place.

I have a excel sheet that pulls data from a sql 2000 table.

I want to update 1 field and send the update back to the sql table.

How do i do this ?????

SO if i update my field in excel from say a number "1" to a number "2" how do i send the update back to the sql table

Me thinks i might need to create a Update Now kind of button....

Kind Regards

Dave

 

[fredericofonseca]

search these forums for ADO, UPDATE and/or INSERT and you will find some samples of what you need.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[xlbo]

you will need VBA for this - as such, please re-post in the VBA forum: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question