Re: Fastest way to Insert Data from 67 Access Databases to One Table in Oracle ?
From: Brad Rhodes (bradrhod_at_online.microsoft.com)
Date: 02/22/05
- Next message: Brad Rhodes: "Re: Cascade update in Oracle Constraint ?"
- Previous message: Stephen Howe: "Re: How set adodb.recordset.filter to a list of long for a long type f"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Feb 2005 12:35:29 -0800
The fastest way would like be to dump the records from Access to a .csv
file, using Access export. Then use Oracle SQL*loader to bulk load the
records in the database.
"Luqman" <pearlsoft@cyber.net.pk> wrote in message
news:%23XxCRZb6EHA.3124@TK2MSFTNGP11.phx.gbl...
> 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
>
>
- Next message: Brad Rhodes: "Re: Cascade update in Oracle Constraint ?"
- Previous message: Stephen Howe: "Re: How set adodb.recordset.filter to a list of long for a long type f"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
