Re: SQL tables to text file

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 23 Feb 2002 21:16:20 +0000 (UTC)
Message-ID: <a590r4$olg$1@paris.btinternet.com>

SQL*XL may be able to help you out here. With SQL*XL you can fetch the data very easially into an Excel spreadsheet. From there it is easy to make the insert statements. If you write them in ANSI SQL you should be able to apply that to any database that supports ANSI. Use the Excel formula concatenate to build your statements. Using SQL*XL you can then execute all the insert statements (using the PL/SQL command).

Have a look at SQL*XL at http://www.oraxcel.com

Regards, Gerrit-Jan Linker Received on Sat Feb 23 2002 - 15:16:20 CST