orange May 14, 5:16 pm show options
Newsgroups: comp.databases.ms-access
From: "orange" <orange...@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 data into database?