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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DTS Package

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2011-05-21 : 10:00:50
Hi All,
Is there any way to upload password protected excel file in SQL Server 2000.

I know the password of excel file. Actually i have created a program in VB.Net 2003 and using DTS method to upload file.

Thanks,

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2011-05-24 : 10:54:20
I don't know the answer to your question though http://www.sqldts.com/243.aspx may provide some clues. I would have thought the password could be provided in the instantiation of the excel object somewhere.

steve

-----------

If debugging is the process of removing software bugs, then programming must be the process of putting them in.
Go to Top of Page

jfarrugia
Yak Posting Veteran

55 Posts

Posted - 2011-05-25 : 04:58:45
As suggested by elwoos.. the password is passed as a parameter.. check http://www.anthony-vba.kefra.com/vba/vbabasic2.htm


Where software development knowledge meets the reader
Go to Top of Page
   

- Advertisement -