Interlogix Topaz Reference Manual - Manual (Page 19)

15
There are several drivers that are already available in the program that can be used to retrieve data
from the following data sources: Microsoft Access 2000, dBASE, Microsoft FoxPro, Oracle, Paradox,
SQL Server and Text file databases. You can also use ODBC drivers or data source drivers from
other manufacturers.
An ODBC driver is a dynamic-link library (DLL) file that Microsoft Query and Microsoft Excel can use
to connect to a particular database. An ODBC driver is a data source driver that conforms to the
Open Database Connectivity standard. Each database program requires a different driver. ODBC
drivers make Microsoft Query flexible, so that you can connect to new databases as they become
available by installing new drivers. For information about installing a data source driver from a
database that is not listed above, consult the documentation that came with the database.
Create a Query
Open Microsoft Excel on your computer. If you are importing this data into an existing Excel spread
sheet, open that file. Select the cell to be used as the starting point for the data that is to be imported.
If you are using an existing file, be certain that there is no data below or to the right of the selected
cell as this data will be overwritten. If this is a new file, select Cell A1.
From the Data Menu of Excel, select Get External Data and then select New Database Query.
This opens the Choose Data Source window which allows you to select the location of your
database.