Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section. Notice that this line of html code contains 'Password=MyPassword.' In this code, MyPassword is the data source password that you saved with the file. In the Find what box, type ConnectionString, and then click Find Next. odc file that has the same name as the data source that you opened in step 14, and then click Edit in Notepad. In the dialog box, search for files named *.odc. Notice that the data is displayed in the active worksheet.Ĭlick Start, point to Search, and then click For Files or Folders. In the Import Data dialog box, click OK to accept the defaults. In the Select Data Source dialog box, take note of the filename that is selected, and then click Open. You receive a warning about how to save the password without encryption. In the Finish step of the wizard, click to select the Save password in file check box. In the Choose Data step of the Data Connection Wizard, select a table, and then click Next. Under Enter the initial catalog to use, select a database on the server, and then click OK. The ODBC connection string has four major parts: the server address, database name, user name and password. Learn how to work with MySQL for beginners and connect to a database for the first time. 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. ODBC connections handle the connection, but each connection string is different depending on your database engine. In the Data Link Properties dialog box, on the Provider tab, click Microsoft OLE DB Provider for ODBC Drivers, and then click Next. 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. In the Select Data Source dialog box, click New Source.

Note In Microsoft Office Excel 2007, click From Other Source in the Get External Data group on the Data tab, and then click From Data Connection Wizard. On the Data menu, point to Import External Data, and then click Import Data. Start Excel and open a new blank workbook. To save the password with the file, follow these steps: The Allow saving password check box was not selected on the Connection tab of the Data Link Properties dialog box, when the connection to the data source was made.Ĭlick to select the Allow saving password check box when you are making the connection to the data source. This occurs even though you clicked to select the Save password in file check box. When you try to import data from a network server in Microsoft Excel, the password you use to connect to the server is not saved.

The password you use to connect to the server is not saved when you import data from a server by using ODBC Connection in Excel

Ms access password connection string