| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connect to OPC / DDE server | Excel Worksheet Functions | |||
| Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
| how to connect SQL 2005 OLAP in excel 2003 | Excel Discussion (Misc queries) | |||
| using a file dsn in sql.request to connect to sql server | Excel Worksheet Functions | |||
| i want to connect excel with sql server 2000 as database with macr | Excel Discussion (Misc queries) | |||
Linear Mode
