anyone know how to convert a txt file into a database (using vb pls --- gonna end up using access ... dont laugh pls). Note....the txt file is not columnar format but the data has consistent spacing.
NAME: PETER LEE HIC: 21111111119A MRN: 1111111
T-REV HCPS UNIT CHARGES FEE-PRICE ASC
L0301 ATPO3 1 $44.20 $14.79 ETC
thanx for anyone who can help.
if possible...a link to the said dilemma would be helpful too =)