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]