Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Question Unanswered: update sql database using excel spreadsheet records

    i have recently recieved an updated spreadsheet for students data. is the anyhow i can update my database table using records from excel. updating them manually will take a long time as they are many records. your help will be appreciated. Thanks

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    How about loading the data into a separate table (lets call it a staging table) and then run SQL to update the live table with the data from the staging table.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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