A query for all the Access gurus out there. I have been given a text
file that needs to be imported into a database for later search and
retrieval. It has 869 records vertically aligned in the following
format:

Name         : A KABAZZI
Expired      : 06/23/97
Lastlogon    : 08/27/98
Totallogons  : 299
Accnt Created: 12/26/96
Home Ph      : <phone # deleted>
Work Ph      : 
Address      :  <address deleted>
City         : <city deleted>
State        : <state deleted>

Name         : A WHITE
Expired      : 04/06/98
Lastlogon    : 07/13/98
Totallogons  : 6032
Accnt Created: 01/22/96
Home Ph      : <phone # deleted>
Work Ph      : 
Address      : <address deleted>
City         : <city deleted>
State        : <state deleted>

I could set it for colon delimited if it were only one record, but not
sure if I'm even able to accomplish this with them formatted in such a
way. Any help would be appreciated to avoid having to manually enter
all 869 of these records.

Thanks,
Ernie Goens

                                  -----
        **Need help with PCSOFT mailing list? Send an Email to:**
        Bob Wright<[log in to unmask]> or Drew Dunn<[log in to unmask]>