SQL Update command to an Excel cell

[gorowan]

Hello

I have gotten a little bit further with my problem...found out how to get SQL commands to work on an Excel database. The following works:

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\External\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$

However, if I change the SELECT command to an UPDATE, query analyser reports a success - however, when I try to open the Excel document in question, I get an MS error report and after a repair the document is still corrupted.

Does anyone have any experience of performing such functions who could help me out?

Thanks in advance...