Connect using Microsoft Access

Viewing:Logging and Plotting Data > ODBC Interface to Query VTS History > ODBC Interface: Connection Examples

Connect using Microsoft Access

This example uses Microsoft Access 2003. The menus will vary depending on the version you are using, but the steps will be essentially the same..

From the File menu, choose Get External Data >> Import.

Select ODBC databases as the File Type.

Select a Machine Data source and look for your DSN name as shown in the figure below:

All tags that are being logged will show up as Tables to be imported. Choose those that you wish to build queries and reports on.

In addition, if you have set a time period specified in the applications’ config.ini file, the data associated with that time period will show as a separate table as described in Configuring Your Application to be an ODBC Server:

Note: By choosing "import" rather than "link tables" in step 1, you will actually import a snapshot of the historical data as it exists at that moment into Access, rather than creating a link to the history file. You will not be able to view new data values created after performing the import. Selecting the Link Tables option is not recommended.