I need to convert an ascii file of multiple lines per record to a .dbf file. The problem I have is when I do the conversion information that should be all in one record becomes multiple records. Each record in the ascii file looks similar to this:
Smith, John 3462 (212)123-4567 456-67-5673
Male 23 Main Street Sep 2,3,4,5,6,9,15,21,22,24
Oct 1,3,6,24
Nov 2,3,4,9,17,
As you can see, not only is the information on multiple lines (between 3 and 7)data overlaps from line to line.
I am at a total loss. By the way, if there is a solution to this using Access, that would be OK.
Thanks.
Joel
Smith, John 3462 (212)123-4567 456-67-5673
Male 23 Main Street Sep 2,3,4,5,6,9,15,21,22,24
Oct 1,3,6,24
Nov 2,3,4,9,17,
As you can see, not only is the information on multiple lines (between 3 and 7)data overlaps from line to line.
I am at a total loss. By the way, if there is a solution to this using Access, that would be OK.
Thanks.
Joel