Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

retrieve and updata from excel into sqlserver 1

Status
Not open for further replies.

indupriya9

Programmer
Oct 29, 2002
99
NZ
I have to perform two tasks in excel.

First task: I have to retrieve the values of two fields (issues and comments) based on a combination of two other fields (title and month) from a table. This table has these 4 fields.

Second task: I have to make the above two fields (issues and comments) editable so that when they edit and save the data they enter into these fields in the database. So that they can access the data they enter next time when they open the spreadsheet.

I am a newbie to VBA in excel. Is this possible to do in VBA. If so, can you provide some sample code for me to use or some documentation that I can read and try to do this.

Any help is appreciated.

Thanks
ip
 
Hi Skip

Thanks for the link. That was exactly what I was looking for. Will try this out and see whether I can achieve what I am trying to do.

Regards
ip
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top