Try using Oracle's OLE objects in Access. The syntax is simple and if you
use parameters (read about them in the online documentation) you should get
excellent performance.
Jim
gerard wrote in message <363E28F7.512F_at_xsoft.demon.co.uk>...
>Hope someone can help with this.
>
>A visual C++ program uses DAO an reads 90,000+ rows from an
>Access table and dumps them into a CSV file in about 10 minutes. The
>same program takes 3 hours to do the same job from a table linked
>through ODBC to an Oracle 8 database.
>
>There seems to be so many ways in DAO to do the same job so
>has anyone any idea how to speed this up ?
>
>Regards Gerard
Received on Tue Nov 03 1998 - 22:06:24 CST
