The selected columns are moved to the right panel. Select the columns you want using the > button.Double click the desired view in the left panel, for example FEMALEEX, PARITYEX, SERVICEEX, SERVICERESULT or TREATMENTEX among others.Place a check mark in the Use the Query Wizard to create/edit queries check box and click OK.Select the DNS that you provided when you created the Firebird ODBC connection. Under “From Other Sources” open “From Microsoft Query”.You can find the instructions to install the ODBC connector at This procedure is only valid for Enterprise and Ultimate editions.įirst you will need to create an ODBC connection.
MS Excel can read Agritec data using an ODBC connector. In this topic I will show how to directly access the database from Microsoft Excel 2010 to retrieve data and do some basic calculations.
0 kommentar(er)
