Greg Graham <GGraham@...> 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]
____________________
Racket Users list:
http://lists.racket-lang.org/users
