Excel data table to oracle

[nouf]

hi,
if i have a tables with data in excel how can i insert all of them into oracle

 

[khm123]

Create your oracle tables as excel one,then you have two ways to solve this first save your excel data as text format then use SQl+ loader to insert your text file which you saved before.
second way user access to make a link to oracle tables then copy your excel tables and paste it on this link.

 

[nouf]

HOW CAN I USE sql+ LOADER FOR THAT AND WHERE CAN I FIND IT AND CAN YOU EXPLAIN THIS OR THE SECOND WAY IN MORE DETAILS PLEASE,,
THANK YOU..

 

[khm123]

SQL+ loader is a tool for Oracle database so check manual for that ,but second way its very simple start an empty access database select tables right click and select link tables then make connect to your oracle database(don't forget odbc connect in Control panel), when link tables be ready then copy your excel sheet and oaste it on link table

 

[khm123]

I hope you inserted it to oracle database.

 

[nouf]

TO KHM123
THANK YOU ...