XL2002: Imported Data Source Password Is Not Saved with File over ODBC Connection (277600)

RESOLUTION

1. Start Microsoft Excel and open a new blank workbook.
2. On the Data menu, point to Import External Data, and then click Import Data.
3. In the Select Data Source dialog box, click New Source.
4. In step 1 of the Data Connection Wizard, under What kind of data source do you want to connect to?, click Other/Advanced, and then click Next.
5. In the Data Link Properties dialog box, on the Provider tab, click Microsoft OLE DB Provider for ODBC Drivers, and then click Next.
6. On the Connection tab, under Specify the source of the data, select a System DSN data source, type the User name and Password, and then click to select the Allow saving password check box. Under Enter the initial catalog to use, select a database on the server, and then click OK.
7. In the Choose Data step of the Data Connection Wizard, select a table, and then click Next.
8. In the Finish step of the wizard, click to select the Save password in file check box. In response to the alert about saving the password without encryption, click Yes, and then click Finish.
9. In the Select Data Source dialog box, take note of the filename that is selected, and then click Open.
10. In the Import Data dialog box, click OK to accept the defaults. Notice that the data is displayed in the active worksheet.
11. Click Start, point to Search, and then click For Files or Folders.
12. In the Search Results dialog box, search for files named *.odc.
13. Right-click the .odc file that has the same name as the data source that you opened in step 14, and then click Edit in Notepad.
14. On the Edit menu, click Find. In the Find what box, type ConnectionString, and then click Find Next.
    
    Notice that this line of html code contains "Password=MyPassword", where MyPassword is the data source password that you saved with the file.