I reading in a text with tab delimited.
For that i use the folowing script:
Do While Not EOF(TXTFile)
Line Input #TXTFile, TXTLine
rst![Extension] = Mid(TXTLine, 29, 4)
rst![Cost_Code] = Mid(TXTLine, 13, 10)
rst![Total_Cost] = Mid(TXTLine, 34, 5)
rst![Date] = strdate_ono
if a word is not four letters long, it puts a space in my table.
can someone help me with this?