Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    12

    Unanswered: how to dump .xls data in to oracle tables ???

    hi all,
    can anyone please help me out to dump excel sheet data into oracle tables........there is a large amount of data and manually doing the same would kill me !!!!!!!!
    please find a way out.....
    thanx in advance.......

  2. #2
    Join Date
    Apr 2004
    Posts
    1

    Re: how to dump .xls data in to oracle tables ???

    try doing the following
    (1) Try to save the file in csv comma separaetd values and try importing thru SQL loader

    (2) Import the excel data into access database and try exporting it from there using odbc datasources

    hope this should work

    with regards

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Well to manually import data from a CSV file into a database such as Access you could get into the database, import the file into a new table, and then run an append query.

    If everything is online then let the CSV file be a recordset that you go through record by record to read and let the regular database table be a recordset to go through record by record to write. You could delete all the related records in the regular database first and then add them all back one by one.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •