retrieve and updata from excel into sqlserver 1

[indupriya9]

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

 

[SkipVought]

Hi,

Check this out...

http://support.microsoft.com/kb/180368

Skip,

_[red][/red]

 

[indupriya9]

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