Hi there,

I wanted to do the same thing and managed to find this great little explanation on the interweb: http://www.databasejournal.com/features/mssql/article.php/10894_3331881_1

Please be aware that these methods of "speaking" to txt, csv and excel files will only work on SQL 2005 32 Bit version. The 64 Bit version has no Jet 4.0 drivers (MS didn't port them).

You can use the examples from the page to read from Excel, but you can use the connection to the openrowset to write back, just use insert into or select into.

Hope that helps

GermanDBA