Need help to import data from excel sheet to oracle database,front end is asp.net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gangadharampidugu
    New Member
    • May 2007
    • 5

    Need help to import data from excel sheet to oracle database,front end is asp.net

    Hi All,
    I need help to import data from an excel sheet to database using .NET. Can anyone please help to do this.Can i read from an excel directly into DB or by using .NET how can i access the file?

    Thanks in advance

    Regards,
    gangadharam
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    If your file format is .CSV then u can use the utility tool SQL LOADER to load data from the sheet directly to the oracle database table.

    Comment

    • gangadharampidugu
      New Member
      • May 2007
      • 5

      #3
      Originally posted by debasisdas
      If your file format is .CSV then u can use the utility tool SQL LOADER to load data from the sheet directly to the oracle database table.
      Actually i will get the file from asp.net screen,so i cannot use command propt..so i cannot use LOADER can I?

      Comment

      Working...