Accessing data using Excel
1 In Excel, click Data > Get External Data > From Other Sources > From Data Connection Wizard.
2 In the Data Connection Wizard, select ODBC DSN, and then click Next.
The VDATA table (the default table for all data presented by the UNICOM Intelligence Data Model) appears.
3 Select the variables you want to bring into Excel.
4 (Optional.) 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 supply only the name of the .udl file when you connect to the database, as follows:
1 In Excel, click Data > Get External Data > From Other Sources > From Data Connection Wizard.
2 In the Data Connection Wizard, click 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>.
The VDATA table (the default table for all data presented by the UNICOM Intelligence Data Model) appears.
4 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