Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Apr 5, 2004

MS Access for the Business Environment: Analyze and Report from the Windows Event Log, Part II - Page 3

By William Pearson

The Import Text Wizard dialog appears, with part of the contents of our log file appearing as a sample, and the Delimited radio button selected by default, as depicted in Illustration 6.

Click for larger image

Illustration 6: The Import Text Wizard with Sample Data

13.  Click Next.

We arrive at the second dialog of the Import Text Wizard, where we can view a preemptory layout of the file, with the default selection of Comma as delimiter type, and the quotation mark (") as the Text Qualifier. We can scroll over and down to ascertain that the delimiting scheme is adequate for our immediate needs. The second dialog of the Import Text Wizard appears as shown in Illustration 7.

Click for larger image

Illustration 7: Second Dialog of the Import Text Wizard - Delimitation Scheme

Because we wish to be able to use "dates as dates" and "times as times" in our analysis of the log data later, we can ensure that "translation" of the imported data to the correct data types occurs here. This will save us the task of changing the data types (they would largely be imported as text, by default) after creation of the table.

14.  Click the Advanced button.

The Import Specification dialog for our file appears. Here we can manage the data type conversions that are enacted upon the text fields we import.

15.  In the Field Information table in the lower half of the Import Specification dialog, type the titles from each Data Element column of Table 1 above into the respective Field Name column.

16.  Change the Data Type to Date/Time for the first two rows, Date and Time, using the selector in the respective Data Type fields. Leave the settings for this field at their defaults for the remaining rows.

The Import Specification dialog, with our modifications, appears as shown in Illustration 8.

Illustration 8: The Import Specifications Dialog

17.  Click Save As.

The Save Import / Export Specification dialog appears. This offers us the opportunity to save our data type specifications for re-use in subsequent imports of the log file we are importing.

18.  Type the following into the Specification Name box of the dialog:

       App Log Import Specification

The Save Import / Export Specification dialog appears as depicted in Illustration 9.

Illustration 9: Saving the Import Specification

19.  Click OK.

We are returned to the Import Specification dialog, which now bears the name that we have saved.

20.  Click OK to return to the second dialog of the Import Text Wizard.

21.  Click Next.

22.  Ensure that the In a New Table radio button is selected in the third dialog of the Import Text Wizard that next appears, as shown in Illustration 10.

Illustration 10: Preparing for Creation of a New Table

23.  Click Next.

The fourth dialog of the Import Text Wizard appears next, as shown in Illustration 11.

Illustration 11: Fourth Dialog of the Import Text Wizard

MS Access Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM