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 |
|
dnivrav
Starting Member
2 Posts |
 Posted - 2002-11-17 : 22:48:55
|
| Can I use a DTS script to download an excel file from a specified location on the company-wide WAN (Intranet) and import certain rows from the excel into a DB table. Is that possible??Or do i have to use Ole Automation....functions..Arvind |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-18 : 01:26:32
|
| If the Excel workbook is properly formatted and you can identify the rows you want, it could work. You would use an FTP- or command task to download the file to your server. Then you just define the connections and make a transform data task.Make sure the excel sheet isn't altered though, might screw it all up. |
 |
|
|
dnivrav
Starting Member
2 Posts |
Posted - 2002-11-19 : 00:05:30
|
| The excel document is in proper format in the certain location.Shouldnt be a problem....So will go ahead with it then!!Cheers!ArvindArvind |
|
|
|
|
|
|
DTS download