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)
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)