Re: Problems with MS Access text export -> sqlldr -> Oracle

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 23 Feb 2002 19:39:54 +0000 (UTC)
Message-ID: <a58r6a$a5l$1_at_knossos.btinternet.com>


Don't know whether you want to go down this route but you may be able to use SQL*XL for part of the solution.

SQL*XL is an addin for Excel that can be accessed from VBA code. It can directly insert data into the database (multiple rows at once) and it can retrieve data from the database directly into a spreadsheet. All of this can be done interactively or without user intervention by means of macros.

SQL*XL can be found at http://www.oraxcel.com

Regards, Gerrit-Jan Linker Received on Sat Feb 23 2002 - 20:39:54 CET

Original text of this message