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

Quote:

Originally Posted by 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

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

Quote:

Originally Posted by amitpatel66

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

Quote:

Originally Posted by alpareshamwala

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

re: Bulk copy in Oracle