var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Import an excel sheet
Is there a way i can import or insert an excel sheet data to an oracle table.
is there a software can help in this issue or a command to do so.
try Oracle 9i External table feature
I have used the (new to 9i) feature of defining a Spreadsheet as an 'External' table.
I remember I had to login as sysadmin to create a directory to put the Spreadsheet but everything else was straightforward.
Then you can use SQL to manipulate the data in the usual way.
Excel and UTF-8
Will the external table feature handle UTF-8 data properly?
We have an Excel file with some VBA code in it which uses SQL to insert,update or delete rows in a table. However, historically, we have had problems with UTF-8 strings.
You can export the Excel spreadsheet to CSV file and then load it with SQL*Loader. It's the same with a external table.
For SQL*Loader you have to create the control file to map the columns and their datatypes, then load the data. Example:
INTO TABLE emp
(empno POSITION(01:04) INTEGER EXTERNAL,
ename POSITION(06:15) CHAR,
job POSITION(17:25) CHAR,
mgr POSITION(27:30) INTEGER EXTERNAL,
sal POSITION(32:39) DECIMAL EXTERNAL,
comm POSITION(41:48) DECIMAL EXTERNAL,
deptno POSITION(50:51) INTEGER EXTERNAL)
$ sqlldr USERID=scott/tiger CONTROL=load.ctl LOG=ulcase2.log
clio_usa - OCP 8/8i/9i DBA