| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: importing comma delimted file
You could consider to use SQL*XL. Simply load the csv file into Excel and
use SQL*XL to load it into the 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:55 CST
![]() |
![]() |