Re: How to populate data from text or MS ACCESS file to ORACLE database?

From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Fri, 15 Jun 2001 16:13:48 -0400
Message-ID: <20uW6.63$Cj6.18338@news.nyc.globix.net>

Jingkai,
1) Use a query in Access to format a data: Exp1: "INSERT INTO Oracle_Table_Name (fld_1,fld_2) VALUES(' " & [Access_fld_1] & " ',' " & [Access_fld_2] & " ');" Pay attention to single quotes within double quotes, there should be NO spaces between them. I spaced them for clarity. 2) save the query, and export it as txt file, fixed width. 3) It's ready to be loaded into the Oracle with SQLPlus:

@file_name.txt

HTH,
Vladimir

"Jingkai Yu" <jkyu_at_cs.wayne.edu> wrote in message news:3B27D95C.4437A8AC_at_cs.wayne.edu...
> I need to populate data from text and MS ACCESS file to ORACLE database
> from within Oracle Developer 2000, is there anybody knowing how to do
> this?
> If so, could you please show me how to do it? Thank you very much for
> your time. You can post message on this board or send it to my mailbox.
> Thanks again.
>
Received on Fri Jun 15 2001 - 15:13:48 CDT