August 26, 2013 at 1:53 am
Hi Everybody,
I'm looking to import an excel file to sql server. Excel file having password.
Is there any way to query the password protected excel files.
Hope that distributed query will help me out.
Please advise.
Thanks
August 26, 2013 at 2:04 am
You'll need to remove the password first. You can do this with PowerShell. This thread posts a solution:
http://www.sqlservercentral.com/Forums/Topic885800-148-1.aspx#bm888553
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2013 at 4:02 am
is there any other way??
August 26, 2013 at 4:51 am
CozyRock has a 3rd party Excel connector for SSIS that can connect to password protected Excel files.
The PowerShell solution is free and it probably won't kill you 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2013 at 4:55 am
how do i get that tool?
August 26, 2013 at 4:57 am
By buying it at the following site:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply