how to transfer excel file into oracle 8i personal edition using VB6?

Answer 1

Use SQLDMO and SQLDTS both are references for the SQL Server. But they should also work with Oracle. But it's a crazy thing. I just do it on an SQL Server and you get mad by solving all the errors you can get.

Helmut

P.S.: A good source to get a idea about it, download the SQL Samples and look for the Bulk Insert Task