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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement