import from txt

orange May 14, 5:16 pm show options Newsgroups: comp.databases.ms-access
From: "orange" <orange..._at_mail.ru> - Find messages by this author Date: 14 May 2005 14:16:49 -0700
Local: Sat,May 14 2005 5:16 pm
Subject: import complex data
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse

I've got a database in .txt file similar to this:

BookName;Author;Year;ReviewedBy;Rating;Pages Nemesis;Isaac Asimov;1989;13,31,24;good;110 Sense & Sensibility;Jane Austen;1970;45,32;great;120 The Bicentennial Man;Isaac Asimov;1965;14;excellent;124
..

the data in field 'ReviewedBy' should be connected to names of people that read the book. I'd like to have a separate table in Access like this:

Id;Reviewer
13;Bob
..

24;Jim
..

31;Tom

How do I import that into database? Received on Sat May 14 2005 - 16:44:53 CDT