How to connect the Excel 2007 in SQL Server 2005?
Hi,
I have found a way to link to Excel 2003 in Sql 2k5. But I cannot link to a
Excel 2007 one. In the link to Excel 2k3, I used the "Produtc String" equal
"Excel 8.0;'. But I do not know what should I use for Excel 2007. I see the
file version of "excel.exe" is 12..., I tried this one, but it is not working.
I know I can always easliy import the excel data into sql using SSIS. I just
want to know if it is possible to link to the Excel 2007 file directly.
Anyway, SSIS is not free :)
|