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