Accessing data using Excel
1 From the Excel menus, choose: Data > Get External Data > From Other Sources > From Data Connection Wizard.
2 In the Data Connection Wizard, select ODBC DSN and click Next. Using the above example you would choose the ODBC data source named MyMRDataSource.
3 You are now presented with the VDATA table (the default table for all data presented by the UNICOM Intelligence Data Model) and can select the variables you want to bring into Excel.
4 Optionally, to edit the SQL syntax, on the last screen of the wizard choose View data or edit query in Microsoft Query.
Alternative method
You can skip creating a DSN altogether, and simply supply the name of the .udl file at the time you connect to the database, as follows:
1 From the Excel menus, choose: Data > Get External Data > From Other Sources > From Data Connection Wizard
2 In the Data Connection Wizard select Connect ODBC-OLE DB Adapter.
3 Excel asks for the Provider and the Data Source. For the Provider choose the UNICOM Intelligence OLE DB Provider. Depending on which version of the UNICOM Intelligence Data Model you are using, this appears in the list as mrOleDB.Provider.n or UNICOM Intelligence DM-n OLE DB Provider (where n is the version number). For the Data Source enter udl://<path of the data link file>.
Using the example from above, you would enter udl://C:\DataLinkFiles\MyDataLink.udl as the Data Source.
4 You are now presented with the VDATA table (the default table for all data presented by the UNICOM Intelligence Data Model) and can select the variables you want to bring into Excel.
5 (Optional.) To edit the SQL syntax, on the last screen of the wizard choose View data or edit query in Microsoft Query.
See also