Creating a Database for Event Analysis and Reporting
We concluded Part I
of this article with an exported text file, containing the data from the Application
log, which we had generated using the Elogdmp utility within a command
prompt window. We now have a data source to import, and upon which to form a
database within MS Access.
the Exported Log Data to MS Access
Let's start MS Access
and proceed, taking the following steps:
Go to the Start button on the PC, and then navigate to the Microsoft
Office Access icon, as we did in the first lesson of this series, Create a Calculated Field with the Expression Builder.
Click the icon
to start MS Access.
Access opens, and may display the initial dialog. If so, close it.
-> New from the top menu.
Database... from the options that are available.
selection can be made from the Task Pane in MS Access 2003, as shown in Illustration
1, among other ways. Depending upon your version of Access, this may
Illustration 1: Select Blank Database ...
The File New Database dialog appears. Here we give
the new database a name and designate where we wish to place it.
into the File Name box of the dialog, after navigating to a place to put
The File New
Database dialog appears as depicted in Illustration 2.
Illustration 2: The File New Database Dialog
Click the Create
The new database is created, and appears as shown in Illustration
Illustration 3: The New Database Appears
--> Get External Data from the main menu.
... from the cascading context menu, as depicted in Illustration 4.
Illustration 4: Select Import ...
The Import dialog appears, from which we can select
the file to import into the new database.
Select the Text
Files option in the Files of Type selector at the bottom of the Import
the location of the exported dump file. (I placed mine, which I called 022004_app.txt, into the D:\temp folder on my computer).
exported log file in the File Name box of the Import dialog, as
shown in Illustration 5.
Illustration 5: The Import Dialog - Dump File Selected
Click the Import