View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davidshen davidshen is offline
external usenet poster
 
Posts: 1
Default 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 :)