How to export/import the excel file in oracle database using sql promt

[sumanta123]

Dear Sir,
How to export/import the excel file in oracle database using sql promt.

Please guide me the command(export/import) for the neddful.

Thanks in Adavance.

Regards
Sumanta Panda

[debasisdas]

you need to use sql*loader for the purpose.

[sumanta123]

Hi Debasis Bhai,
Thanks for your response.I never used the sql*loader.Coul d you please
write the command of export/import for excel file in sql*loader.

Thanks in advance.
Regards
Sumanta Panda

[debasisdas]

please find the details in the following links
link1
link2
link3
link4

[sumanta123]

Thank you Debasis Bhai.

[debasisdas]

You are most welcome sumanta.

I hope that solved your problem of data loading from flat files.