Convert data captured Excel into Oracle database via SQL

[BenjaminLim]

Have anyone tried the above.

I need help to convert columns of data captured in Excel files into Oracle database via SQL synthax.

Please advice.

Thanks.

Benjamin

 

[tlbroadbent]

Are you using T-SQL in SQL Server to do this or SQL in Oracle? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[BenjaminLim]

tlbroadbent,

I am using SQL in Oracle to do this. (SQLPlus 3.3)

 

[tlbroadbent]

You should post your question in an ORACLE forum. There are several of them. This forum deals with Microsoft SQL Server. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.