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]>
|