Hello All,
Can you please help me with macro to insert data from excel sheet to Oracle database.
Table is already created in database.
Table Name: TEMP_LOCATION
Sample data is given below: [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 576"]
ITSet
[/td]Country
[/td]Site Code
[/td]Terrain Alias
[/td]Terrain Name
[/td]Building
[/td]Building Area
[/td]Room
[/td]ACTION
[/td]ABC
[/td]DEF
[/td]HRTH
[/td]JKLTH
[/td]MNO
[/td]PQR
[/td]STU
[/td]VWX
[/td]YZ
[/td]DFG
[/td]RY
[/td]THRTH
[/td]JKLTRH
[/td]RTE
[/td]PQR
[/td]STU
[/td]VWX
[/td]YZ
[/td]RGRTTR
[/td]TRH
[/td]RTH
[/td]ERRE
[/td]MNO
[/td]PQR
[/td]STU
[/td]VWX
[/td]YZ
[/td]
[/TABLE]
Thanks:)