>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
SQL Loader runs at the OS level [DOS utility]. Yes you could call it like any other DOS command. I have VFP code that will create the data text file, and the SQL Loader control and paramter files. The loader is by far a faster way to transfer large amounts of data to Oracle.
Mark McCasland
Midlothian, TX USA