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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-08 : 09:49:33
|
| Nick writes "In SQL Server 7.0, when you selected an Excel data source to connect to, you got a box for the FileName and two additional boxes for a username and password.In SQL Server 2000, the username and password boxes have *disappeared* for Excel datasources. How can I connect to a password-protected Excel file when there's no place to put in a password?Problem replication:1) Create an excel workbook and password-lock it using the 'Save As' Options button.2) Open SQL Server 2000 Enterprise Manager and right-click on the 'Data Transformation Services' folder and choose 'All Tasks >> Import Data'.3) Click 'Next' to get to the Choose a Data Source dialog. Choose any Excel driver (3.0, 4.0, 5.0 or 97-2000) and then browse for your file that you created in step 1.4) Hit next and watch SQL Server throw decryption errors at you.Is it just me? The dialog says verbatim, 'To connect to Microsoft Excel, you must first choose an Excel file. You may need to provide a valid user name and password.'But there is no textbox for username or password!Help!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-11 : 19:22:47
|
| http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q211378Same error on 7.0 even if you put in the password.-Chad |
 |
|
|
|
|
|
SQL Server 2000 - DTS Import Excel Worksheets w/Password Protection