Hi all,
My friend was able to provide me an idea on how to do my program, however, I think he's logic is for Excel VBA instead of Access. Can someone help me translate what he's trying to say into Access VBA?
My friend was able to provide me an idea on how to do my program, however, I think he's logic is for Excel VBA instead of Access. Can someone help me translate what he's trying to say into Access VBA?
Code:
Open file
Set arrayidx = 0
Initialize Array
While not EOF Do
Read file
If line contains 0~0~ES~
{
If arrayidx = 6
{write array 1 to 6 into table}
End If
Initialize array
Set arrayidx to 1
}
End If
Move line to array
Set arrayidx = arrayidx + 1
End While