Re: Oracle 8i: Importing CSV Files

You could consider to use SQL*XL. Simply load the file into Excel and use SQL*XL to pump it into the database. It is a bit more userfriendly than SQL*Loader. You can view all exceptions in Excel and failed rows are easially resubmitted.

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
"Andy Snodgrass" <andy.snodgrass_at_telecaXXX.com> wrote in message news:ap3h7p$j8o$1_at_reader0.news.uk.quza.net...
> Hi,
>
> I have a large (100s of 1000s of lines long) CSV file that I want to
import
> into an Oracle table. I am using Oracle 8i.
>
> * What are my options?
>
> * I have heard of a tool called SQL*Loader is this provided as standard
with
> Oracle 8i?
>
> An inexpensive (i.e. free) solution would, if possible, be best.
>
>
> cheers
> andy.
>
>
Received on Sun Nov 10 2002 - 10:59:55 CST