locked
Import data from excel file into sql server table in sql server 2008 R2 ? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Step 1 --> I DID.

    Simple copy all excel file records, records are 16000+ and paste into sql server table. Right click to table and choose edit 200 records option.

    But records paste not exactly what excel file has.there having mismatch in the records pasted into table.

    I want to Import data from excel file into sql server table in sql server 2008 R2.

    Which is easiest approach for the same.


    • Edited by Maggy111 Tuesday, October 30, 2012 1:05 PM
    Tuesday, October 30, 2012 1:02 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    This is the easiest task..

    Right click on your Database -> Tasks - > Import Data

    GUI will open up in data source select excel, select path where excel file is kept...

    • Proposed as answer by Naomi N Tuesday, October 30, 2012 2:14 PM
    • Marked as answer by Maggy111 Monday, November 5, 2012 7:02 AM
    Tuesday, October 30, 2012 1:11 PM