Re: Import data from an excel file??
export from excel as .csv, tab seperated usually works
load data infile '/tmp/file.csv' into table tableName ignore 1 lines
lose the ignore 1 lines if your file does't have a header row.
try it with a small selection of data against a test table first.
Subject
Views
Written By
Posted
6687
June 01, 2005 09:08PM
Re: Import data from an excel file??
4090
June 28, 2005 02:40AM
4033
May 15, 2008 11:54PM
3738
May 21, 2008 11:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.