Re: import from txt

orangeKDS_at_mail.ru wrote in
news:1116107093.655887.293450_at_g44g2000cwa.googlegroups.com:

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

> I'd like to have a separate table in Access

And exactly what does this question have to do with Oracle?

SQLLDR is documented at http://tahiti.oracle.com Received on Sat May 14 2005 - 17:03:58 CDT