Insert data from excel sheet to oracle table periodicaly

[Userdom]

I need to insert and update every day data of employees from excel sheet to oracle table

and every day i have to make the same charge to the oracle table in specific hour

can somobody help me please...


thank

[debasisdas]

Thread moved to Oracle Forum.

[RAYOFHOPE]

Save your Excel file in CSV Format.
Use SQL LOADER to load data to Oracle.

You can create a bat file to run sql loader every day after updating and saving the excel file as CSV.

Hope it helps

I need to insert and update every day data of employees from excel sheet to oracle table

and every day i have to make the same charge to the oracle table in specific hour

can somobody help me please...


thank

[Userdom]

I do this

LOAD DATA
INFILE 'c:\carga'
INTO TABLE empleado
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(tarjeta, nombre, tiponomina)

but I get this error
invalid sql statment

I Using oracle express

I dont know if I need to do this in a procedure or package for use data loader. now I only do it in the sql command

[Userdom]

I alredy know how to charge de data I only make an external table an after I do an insert into my table from external table and its all rigth but now I need to make this automaticI try a file.bat but I get and error when I run it.


the error star when star read in organizacional external part of the script

create table external2
(
camp1 char(5),
camp3 varchar2(2),
camp3 varchar2(30)
)
organization external
(
type oracle_loader
default directory external1
access parameters

(

records delimited by newline
fields terminated by ","
(

camp1,
camp2,
camp3 )

location(carga.csv')

)

reject limit unlimited
;



if some body can help I'll be thankfull