Hello All,
I have a problem. I have an excel document that link to a SQL Server and I need to figure out how to do the following;
I have a bit of code that simple Select data from a table and copy the recordset in an excel sheets. Simple. Next part is the bit causing me some problems. The data that is copied on to the excel sheet needs to be updated (by changing the values in the cells manually) and some how copied back to the recordset and updated on the SQL Server.
If anyone has any idea of the best way to tackle this or can point me in the right direction would appreciate the input.
Many Thanks
Bantler
I have a problem. I have an excel document that link to a SQL Server and I need to figure out how to do the following;
I have a bit of code that simple Select data from a table and copy the recordset in an excel sheets. Simple. Next part is the bit causing me some problems. The data that is copied on to the excel sheet needs to be updated (by changing the values in the cells manually) and some how copied back to the recordset and updated on the SQL Server.
If anyone has any idea of the best way to tackle this or can point me in the right direction would appreciate the input.
Many Thanks
Bantler
