>HI,
>Is there a way to control the autocommit with ADO and Oracle 7 within VB? I would like to know if autocommit is on or not when I issue an INSERT command. I have to Insert nearly 400000 rows that are in an Access Database and it takes 8-10 hours to complete.
>
>Thank you,
>Christian Cote
One other question, is this just a one shot deal, or will you have to do this on a regular basis? If you have to do this more than once, you will be better served learning how to use the SQL Loader utility. If interested, I can provide help with that as well.
Mark McCasland
Midlothian, TX USA