Flat File Reading

Summary: I have one requirement as mentioned to read in the ATP database in two tables. What are the best possible ways to read the file considering it to be more than 10 MB to 1 GB considering performance. All ideas are appreciated.

File Contents: .txt file

H123 34 12 35

L 35 26

L 78 21

H342 22 11 11

L 11 34

Table 1

Col1 Col2 Col3 Col4

H123 34 12 35

H342 22 11 11

Table 2:

Col1 Col2 Col3

H123 35 26

H123 78 21

H342 11 34

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):