orange May 14, 5:16 pm show options
Newsgroups: comp.databases.ms-access
From: "orange" <orange... (AT) mail (DOT) 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?

Hi

This is a SQL Server newsgroup, therefore you may want to post to a
newsgroup more specific to your subject.

You can import a text file from the Insert/table menu. For your 'ReviewedBy'
field you can define relationships using the Tools/Relationships menu. This
will make sure that they are only existing users.
To copy them into subsequent tables then you can write Append queries that
will produce queries like INSERT INTO NewTable SELECT Id, ReviewedBy FROM
LoadedDataTable if you view the SQL.

HTH

John

<orangeKDS (AT) mail (DOT) ru> wrote