Text File

[Treason]

I have a Text file listing Student ID's and Exam Grades. I have imported this txt file into access. The problem is the way the data is listed seems to be useless. The Database looks like...

1234567890__MATH EXAM_85
____________SCI EXAM__92
____________ENG EXAM__99
1432453252__MATH EXAM_92
____________SCI EXAM__73
____________ENG EXAM__55
Etc...

My problem is the Student's ID is not repeated in the field. So they are not related. The only ideas I have to fix this Database would be to create a module that would say if the Student ID field is Null, Then take the Stud_ID from the previous record. I really hope this makes sense, because I dont see too many options. Any ideas at all are appreciated.

 

[cpod]

There is an easy way to do this if you can import the file into Excel:

Let's say you have imported the file into Excel with the student ID in column A and exam data in column B. With a header row, the first id number is in A2.

1. Select A2 and down to the last row with data in column B.

2. Then: Edit/GoTo/Special/Blanks/OK

The blank cells in column A should be selected.

3. With the blank cells still selected, type "=A2" and then hold the Control key down while pressing the enter key.

All the empty cells should fill in. It looks a little complicated, but it's a lot easier to do than to describe.

 

[Treason]

EXCELLENT!!!!

You Are The BEST! lmao

Thanks a million