From: Galler (lzgaller at optonline.net) Date: Thu Oct 11 12:53:10 EDT 2012 |
|
Greg Graham <GGraham at ...> writes: >>do you think this is a crazy idea or not? I won't call it crazy. Can I call it overengineered? I would write the following in T-SQL to achieve what you want: sp_configure 'Ad Hoc Distributed Queries', 1 reconfigure USE [your-database] GO insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test.xls','select * from [sheet1$]') SELECT CODE FROM dbo.[your table name]
Posted on the users mailing list. |
|