Bulk copy in Oracle

[alpareshamwala]

Hi
Friends,
i wanted to bulk copy an MS Excel file to Oracle Database the way "bcp" is used in MS Sql Server.

pl. help ASAP
Alpa

[amitpatel66]

Hi
Friends,
i wanted to bulk copy an MS Excel file to Oracle Database the way "bcp" is used in MS Sql Server.

pl. help ASAP
Alpa

Please clarify if you want to copy a FILE or the contents of the file in to oracle database?

[debasisdas]

Convert the .xls file to .csv format and then use the SQL Loader utility for data loading.

[alpareshamwala]

Please clarify if you want to copy a FILE or the contents of the file in to oracle database?

i would like to copy the contents of the file to oracle database

[amitpatel66]

i would like to copy the contents of the file to oracle database

Hi alpareshamwala,

Kindly refer to post #3 above to copy the data to the oracle database table.

Amit