ADO and Large Text File


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO and Large Text File

  1. #1
    Dante Guest

    ADO and Large Text File


    I am developing a system using VB 6 SP3 ADO 2.1 and Oracle 8.0.5.
    For my connection I use con.Provider = "MSDAORA".

    1) My program needs to convert a large text file into my Oracle
    Table. What is the most efficient and reliable way to
    do this?

    2) The program also needs to generate a large text file from
    one Oracle Table. Again, what is the most efficient and
    reliable way to accomplish this?

    Please help.

    Dante

  2. #2
    Robert Gelb Guest

    Re: ADO and Large Text File

    Barring the use of BCP, for problem #1 I'd simply do an insert after insert.
    For problem #2, try a client-side cursor then dump it all into an XML file
    using Recordset.Save

    This is great because you can then easily reload the file into the database
    or show it in teh browser using a style sheet or XSL file.

    --
    Robert Gelb
    www.vbRad.com
    Source, Tips, Tricks, Components

    "Dante" <dantedt@yahoo.com> wrote in message
    news:39ba5eb9$1@news.devx.com...
    >
    > I am developing a system using VB 6 SP3 ADO 2.1 and Oracle 8.0.5.
    > For my connection I use con.Provider = "MSDAORA".
    >
    > 1) My program needs to convert a large text file into my Oracle
    > Table. What is the most efficient and reliable way to
    > do this?
    >
    > 2) The program also needs to generate a large text file from
    > one Oracle Table. Again, what is the most efficient and
    > reliable way to accomplish this?
    >
    > Please help.
    >
    > Dante




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center