Best way to get text data into a database?

[Kila]

I am trying to extract data from a survey that is buried in a patient note. The portion I am attempting to utilize is attached below. The database is normalized. Question 1 has a fixed ID of 52 with possible Answer IDs of 12, 15, 34, 49, and 75, for example. So when it is saved, CompletedSurveyID 123 has AnswerID 12 for QuestionID 52 on SurveyID 2. Of course, the text of the question and answer is all the user sees...the database is set up for direct entry, but the decision was made to make the survey part of the patient's electronic chart. To prevent duplicating effort (since some of the surveys are quite long) I would like to import this data...probably by pasting it to a text file and importing it (unless someone has a better idea).

Can anyone recommend a good plan to capture this data? The text file looks like this:

1. Text of Question 1
- 5 - Very Good
2. Text of Question 2
- 4 - Good
3. Text of Question 3
- 5 - Very Good
4. Text of Question 4
- 4 - Good
5. Text of Question 5
Text Question 5 Line 2
- 5 - Very Good
6. Text of Question 6
- 4 - Good
7. Text of Question 7
- 5 - Very Good
8. Text of Question 8
- 4 - Good
9. Text of Question 9
Text of Question 9 Line 2
- 5 - Very Good
10. Text of Question 10
- 4 - Good
11. Text of Question 11
- 5 - Very Good
12. Text of Question 12
- 4 - Good

Thanks in advance for any suggestions!