Importing a Text File with difficult formatting/layout

W

Wally Steadman

I have a text file that looks like the snippet below and am wondering if
anyone knows of a way to get this type of file to import into fields in a
DB. Or any work arounds that might help import this data.

Date 1 Aug 03 Time 1600

Data1 Data2 Data3 Data4 Data5
12 15 25 12 14

Data6 Data7 Data8 Data9 Data10
16 14 13 19 23

Reported by Persons Name

So the information I am trying to see would be in a table with the following
fields

Date
Time
Data1
Data2
Data3
Data4
Data5
Data6
Data7
Data8
Data9
Data10
Reported By:

All the fields will be in one table and then I will be able to query from
there. I will be compiling reports that are reported in this format every
hour from multiple sites. The format cannot be changed by the user based on
the software that generates the report.

Would appreciate any assistance.

--
Walter Steadman
CW2, USA
124th Signal Battalion
Network Management Tech
(e-mail address removed)
 

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

Excel macro concatenate each 2 rows data into 1 row for all sheet 2
How to select values in sequence order? 3
Select to reference an other record or row 1
How do I combine records 1
find lowest number and return it's adjacent cell 7
change cell name to text nmae 1
naming cells for their content 3
dates into week total 3

Top