Re: importing data in from text file

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 10 Nov 2002 16:59:54 +0000 (UTC)
Message-ID: <aqm3aa$cin$3@sparta.btinternet.com>

You could consider to use SQL*XL if you move away from the requirement to load it from the DOS prompt.
SQL*XL will allow you to load the file into Excel use the Excel command Text to Columns to get the individual fields into Excel cells. After this SQL*XL can be used to insert the data straight from Excel into your database.

SQL*XL specialises in dealing with databases from MS Excel. It works with all databases and has been tested to work fine against Oracle, Access, Foxpro, SQL Server, Sybase, etc etc

SQL*XL is full featured. You can use Excel cells in the SQL, it supports macro recording, VBA coding, scripting, comes with an installer/uninstaller and has a help system.

Find SQL*XL at www.oraxcel.com

I suggest you download both SQL*XL3 and SQL*XL ADO

Kind regards, Gerrit-Jan Linker Received on Sun Nov 10 2002 - 10:59:54 CST