Import text file merging first 2 lines as column headings

  • Thread starter Thread starter Java
  • Start date Start date
J

Java

How can I import into MS Access a file like this but I need the 1st lines as
the column headings?
Ex. Field Rcd Pos Field Text Description Length No of Digits Dec
Pos Field Type

Field Rcd Field Text Length No. Of Dec Field
Pos Description Digits Pos Type
KEY1 1 PRODUCT 10 0 0 A
KEY2 11 PO TYPE 10 0 0 A
KEY3 21 UNUSED 10 0 0 A
EFDTE 31 EFFECTIVE DATE 8 8 0 S
DESC 39 CODEFILE DESC 30 0 0 A
 
Hi,

Are these delimited by tabs or spaces? If tabs, it is easier. If
spaces it could be a problem. Assuming tabs, you could import everything
into a work table with a sequential autonumber primary key and the rest of
the fields as text. Then you could use the first two rows to determine the
column names and transfer the remaining lines into where ever it is that you
want them to go.

Or, you could write your own custom import process.

Clifford Bass
 
Back
Top