How to send data back to sql from excel

[sthiru]

Hi,

i have a sql database and lot of tables.
I want to insert and update a sql table from excel. I can retrieve the data from sql table to excel sheet. But i have to send the data back to sql with the changes if any, from excel sheet. I have struggling in this part.

This is my problem.

Can you help any one to solve this problem.

Thanks in advance.

Thiru.

[vinot85]

Hi,

i have a sql database and lot of tables.
I want to insert and update a sql table from excel. I can retrieve the data from sql table to excel sheet. But i have to send the data back to sql with the changes if any, from excel sheet. I have struggling in this part.

This is my problem.

Can you help any one to solve this problem.

Thanks in advance.

Thiru.

You could use Visual Basic Macros If I am not wrong. But, it is slight tough to build efficient.

My suggestion is to replace the Excel Sheet with MS Data Grid control and updating there to get it reflect in Sql databases.