Importing text file with header & footer

V

Vann

Is there an easier way to import a text file into Access
without manually removing the header & footer? Here's my
file layout. I copied & pasted it from Notepad. Thanks!

11/12/2003
Dynamic List
Display
1
-----------------------------------------------------------
-----------------------------------------------------------
-------------------
-----------------------------------------------------------
-----------------------------------------------------------
-------------------
| DocumentNo|RefDocNo|Cost ctr|ActTyp|Cost elem.|Cost
element name | ValueCOCur|Quantity|PUM|Postg
date|Pers.no.|Partner object |
-----------------------------------------------------------
-----------------------------------------------------------
-------------------
| 301461779 |605120 |52110 |AT-BUS|600055
|Maintenance | 75.03-| 1.000-|H
|08/01/2003| 5459|5529220 |
| 301461780 |597672 |52210 |AT-LR |600055
|Maintenance | 77.10-| 1.000-|H
|08/01/2003| 11100|5522851 |
| 301461781 |597664 |52210 |AT-LR |600055
|Maintenance | 308.40-| 4.000-|H
|08/01/2003| 11100|5522843 |
| 301461782 |566873 |52210 |AT-LR |600055
|Maintenance | 192.75-| 2.500-|H
|08/01/2003| 11100|5495506 |
| 301461783 |597664 |52210 |AT-LR |600055
|Maintenance | 308.40-| 4.000-|H
|08/01/2003| 8092|5522843 |
| 301461784 |610826 |52210 |AT-LR |600055
|Maintenance | 38.55-| 0.500-|H
|08/01/2003| 8092|5534140 |
 
Top