HI Mark,
I do not have any Indexes on this table. It is simply a copy of the original table in Access that I need to extract some datas in Oracle after the load. We do it 3-4 times a year.

Is SQL Loader able to import Access data natively ? I thought that it accepted only text files. I must provide a VB interface (I am a VFP programmer since 4-5 years, I think it would be easier or faster in VFP) because they want to automatize the whole process. Once it has been loaded in Oracle, VB simply call an Oracle stored procedure that begins all the extractions/transformations needed.

Will VB be able to call SQL loader ?

Thank you for your help,
Christian Cote