Insert Data from Access Database to Oracle ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luqman - 25 Dec 2004 22:32 GMT

Is there any fastest way to Insert Data from 67 Access Databases of about
10,000 records each (Total 670,000 records) to One Table in Oracle ?
Curently I am using VB-6 and reading each record of each database using ADO
AddNew/Update Method to Insert into Oracle,but it takes much time.
Can I use XML or text file or any other tool ?

Best Regards,

Luqman

Reply to this Message

Ant - 29 Dec 2004 13:07 GMT

An INSERT INTO statement would be the fastest I would think.

INSERT INTO newTBL
    (fld1,fl2,fldn)
            -- NOTE: no 'VALUES' keyword needed
SELECT     fld1,fl2,fldn
FROM    oldTBL

Reply to this Message

Christoph Basedau - 29 Dec 2004 13:22 GMT

25.12.2004 23:32, Luqman schrieb:

> Is there any fastest way to Insert Data from 67 Access Databases of about
> 10,000 records each (Total 670,000 records) to One Table in Oracle ?
> Curently I am using VB-6 and reading each record of each database using ADO
> AddNew/Update Method to Insert into Oracle,but it takes much time.
> Can I use XML or text file or any other tool ?

con.execute "INSERT INTO <OracleTable> IN <path to Oracle-DB> SELECT * FROM
<accesstable>"

Is probably a bit faster. If table structure defers, you have to select
only the columns that fit and use column-aliases for selecting into the
right target-column.

Signature

Gruesse, Christoph

Rio Riay Riayo - Gordon Sumner, 1979

Reply to this Message

VB Forum / Database Access / December 2004

Insert Data from Access Database to Oracle ?