Configuring a Data Source for Microsoft Access

If you want to export data to Microsoft Access, you must configure a data source. You do not have to have Access installed to complete this procedure. (Of course, you will not be able to manipulate the database without Access installed. However, you can open the database in Microsoft Excel, as described in Importing Data from Access to Excel.)

Procedure 189: Configuring an ODBC Data Source for Microsoft Access in Windows XP

  1. Open the Control Panel.

  2. Double-click Administrative Tools. (It is part of the Performance and Maintenance group if your Control Panel groups applets.) The Administrative Tools folder opens (Figure 155).

    Figure 155: Administrative Tools applet window

    Administrative Tools applet window

  3. In the Administrative Tools folder, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box opens (Figure 156).

    Figure 156: ODBC Data Sources Administrator

    ODBC Data Sources Administrator

  4. Select the System DSN tab.

  5. Click Add. The Create New Data Source window opens (Figure 157).

    Figure 157: Create New Data Source window

    Create New Data Source window

  6. Select Microsoft Access Driver (*.mdb).

  7. Click Finish. The ODBC Microsoft Access Setup dialog box opens (Figure 158).

    Figure 158: ODBC Microsoft Access Setup dialog box

    ODBC Microsoft Access Setup dialog box

  8. In the Data Source Name box, type a name for the data source.

  9. In the Database group box, click Create. The New Database dialog box opens (Figure 159).

    Figure 159: New Database dialog box

    New Database dialog box

  10. In the Database Name box, type a name for the database, for example, myNewLoggerExport.mdb.

  11. In the Directories list, select the directory where you want to create the database.

  12. Click OK. An informational prompt advises you that the database has been created (Figure 160).

    Figure 160: Information prompt

    Information prompt

  13. Click OK.

  14. Continue clicking OK to back out of the dialog box sequence.

The next time you export a Logger file to database using the Microsoft Access driver and data source, it is exported to the database file you created in this procedure.