Updating db via xml
Updating db via xml
You can create Office Data Connection (ODC) files (.odc) by connecting to external data through the Select Data Source dialog box or by using the Data Connection Wizard to connect to new data sources.An ODC file uses custom HTML and XML tags to store the connection information.
After you create the connection, you can use the Connection Properties dialog box (On the Data tab, in the Get External Data group, click Properties.) to control various settings for connections to external data sources, and to use, reuse, or switch connection files.(On the Data tab, in the Get External Data group, click Connections.) You can use this dialog box to do the following: Connection files are particularly useful for sharing connections on a consistent basis, making connections more discoverable, helping to improve security of connections, and facilitating data source administration.The best way to share connection files is to put them in a secure and trusted location, such as a network folder or Share Point library, where users can read the file but only designated users can modify the file.After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.Connection information is stored in the workbook and can also be stored in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Data Source Name file (.dsn).Query files are a traditional way for sharing queries with other Excel users.
Using query files You can use Microsoft Query to save files that contain queries for data from relational databases or text files.
Top of Page To find connection files, use the Existing Connections dialog box.
(On the Data tab, in the Get External Data group, click Existing Connections.) Using this dialog box, you can see the following types of connections: You can also use Excel as a connection file editor to create and edit connections to external data sources that are stored in a workbook or in a connection file.
Using query files You can save files to connect to data in an OLAP database, either on a server or in an offline cube file (.cub).
When you use the Multi-Dimensional Connection Wizard in Microsoft Query to create a data source for an OLAP database or cube, an file is created automatically.
If the data source is a database, make sure that the database is not opened in exclusive mode.