Import text file merging first 2 lines as column headings

J

Java

How can I import into MS Access a file like this but I need the 1st lines as
the column headings?
eg
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import text file merging first 2 lines as column headings 1
parse text w/ line input 1
Ever wondered how to work with large text imports >256 columns? 0
Text import and transpose - pretty difficult 5
Import & Parsing a small 400 line CSV file 3
Column names for dump of text file to Excel 1
Date Import from Text File 3
Import File Line by Line 1

Top