hello,

i have a small project which i wanna do with vb. i have a text file with some data. it is in this format...

0010 CHOLERA D/T VIB CHOLERAE
0011 CHOLERA D/T VIB EL TOR
00320 LOCAL SALMONELLA INF NOS
00321 SALMONELLA MENINGITIS
00322 SALMONELLA PNEUMONIA
00323 SALMONELLA ARTHRITIS
00324 SALMONELLA OSTEOMYELITIS
00329 LOCAL SALMONELLA INF NEC
0038 SALMONELLA INFECTION NEC
0039 SALMONELLA INFECTION NOS
0040 SHIGELLA DYSENTERIAE
00581 FOOD POISN D/T V. VULNIF
00589 BACT FOOD POISONING NEC
0059 FOOD POISONING NOS

... and so on.

it is saved as a text file in notepad. i wanna export or transer this into ms-access. the table there has two fields... the first field contains the numbers or codes above and the second field has all the rest (description).
the catch here is, that i need to introduce a decimal point after the first three characters in the first field. AND, THE FIRST FIELD SHOULD BE OF TYPE "TEXT" AND NOT "NUMBER".

how do i go about this. I am able to export the entire line into one field in access... but am not able to split the data. also, am not sure how to include the decimal point in a text!

any help would be greatly appreciated. thanks in advance...