I am trying to import several hundred records into Access from a txt file but I can't find a way to separate the file into individual records. A portion of the file is given below and I would welcome any assistance:
'C Olive Teece', 'Census, 1940', 'birth: 1919 New York', 'residence: 1940 Ward...