| Import Wizard Example 1
Import Example 1: Multiple Lines Per Record
Import Example 2: Multiple Headers
Import Example 3: Address List
Import Example 4: Delimited Web Server Log File
Import Example 1: Multiple Lines Per Record
A commonly encountered import problem: each record consists out of multiple lines. Using Import Wizard you can import multiple lines into single records and include header and/or footer information as required.
File For Import
==========================================================
Employee Hours Report Page: 1
Company: XYZ Company Date Printed:02/02/99
==========================================================
Employee Date Regular Hours/ Other Hours/
Overtime Code
----------------------------------------------------------
Doe, John 01/23/99 23.3 1.6
15.6 AC
----------------------------------------------------------
Wacks, Gene 02/01/99 1.6 0.0
0.0
----------------------------------------------------------
Peters, Kate 01/30/99 40.3 3.4
1.1 VA
----------------------------------------------------------
| |
Table Imported with Import Wizard
| Employee |
Date |
Regular Hours |
Other Hours |
Overtime Hours |
Code |
| Doe, John |
1/23/99 |
23.3 |
1.6 |
15.6 |
AC |
| Wacks, Gene |
2/1/99 |
1.6 |
0 |
0 |
|
| Peters, Kate |
1/30/99 |
40.3 |
3.4 |
1.1 |
VA |
Example 1 2 3 4
|
