Fastest way to Insert Data from 67 Access Databases to One Table in Oracle ?

From: Luqman (pearlsoft_at_cyber.net.pk)
Date: 12/24/04

  • Next message: Ashwin: "Key column information insufficient....ERROR" 
    Date: Fri, 24 Dec 2004 17:45:51 +0500

    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: Ashwin: "Key column information insufficient....ERROR"

    Relevant Pages

    • Re: Insert Data from Access Database to Oracle ?
      ... 23:32, Luqman schrieb: ... > Is there any fastest way to Insert Data from 67 Access Databases of about ... > Curently I am using VB-6 and reading each record of each database using ADO ...
      (microsoft.public.vb.database.ado)
    • Insert Data from Access Database to Oracle ?
      ... Is there any fastest way to Insert Data from 67 Access Databases of about ... Curently I am using VB-6 and reading each record of each database using ADO ... Luqman ...
      (microsoft.public.vb.database.ado)
    • Advantages of $?
      ... I have recently taken over a number of Access databases. ... developer used the $ symbol randomly for functions or thier arguments. ... remember reading about the differance between using the $ symbol and not ... I personally do not see a reason for it's use. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Importing / Exporting / Full application Creation Advise Plea
      ... Please post all follow-up questions to the newsgroup. ... I am only familiar with basic access databases, excel spreadsheets ... for use on the internet...so how does XML fit in to this. ...
      (microsoft.public.office.misc)
    • Re: Importing / Exporting / Full application Creation Advise Plea
      ... Please post all follow-up questions to the newsgroup. ... I am only familiar with basic access databases, excel spreadsheets ... for use on the internet...so how does XML fit in to this. ...
      (microsoft.public.office.misc)