import to sql server from excel

[nisha]

Hi,

I want to export the data from SQl server to an excel and then allow the user to modify the excel and update back the data to the sql server. Any suggestion on how to implement the above. The first part i.e exporting to excel is now working fine it will be great to know about the import functionality.

Any help on this...!!!

Thanks in advance