Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kavitaravi
Starting Member
2 Posts |
 Posted - 2005-08-11 : 07:22:12
|
| Hi, I am configuring the Excel DTS Connection object as follows:DTS.Connection objSourceConnect; objSourceConnect = moPackage.Connections.New("Microsoft Excel Driver (*.xls)");objSourceConnect.ID = 1;objSourceConnect.ConnectionProperties.Item("Extended Properties").Value = "Excel 8.0;HDR=YES"; objSourceConnect.DataSource = @"D:\ProductData.xls";But data transfer is not taking place into the SQL server destination table.Any idea how the connection object for Excel files be configured?Kavita |
|
|
|
|
|
DTS Connection object properties for Excel