ADO and Large Text File

[Dante]

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

[Robert Gelb]

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