Data Transfer

[t848]

Our office has a scanner that reads a sheet of fields where people have colored in the dots that have the date , school name course name ect…My problem is that there are 28 fields with social security numbers on that 1 sheet and I need the vb code that will take SSN1, SSN2 SSN3 ect… and write that data to a data field named SSN in an access data base. I already have the TXT file that the scanner writes where it will import into the data base.
I would appreciate any help that any one could give me
T848

 

[alastair69]

is there a common seperation between the field name i.e ";" or something like it.

 

[t848]

yes there is a comma between the fields and i have the data where it will import from a TXT to the database file.