Using Excel to update a SQL table

[Uncle Dickie]

Hi All,

I have an situation where I am exporting from our SQL database a list of open purchase orders. In Excel, a user will be able to add a comment against any of these in a new column and then, when they run a Macro, it has to store the PO Number, Comment and today's date in to a separate table I have created in the database.

Is this possible and if so does anyone have any pointers for doing the update?

Thanks in advance,

Richard

[ck9663]

Yes, but it's more of a .Net/VBA/Excel question than a SQL Server question.

Good Luck!!!

~~ CK