How to upload data from Excel into SQL Server 2005

310 pts.
Tags:
Microsoft Excel
Microsoft Excel import/export
SQL Server 2005 import/export
SQL Server import/export
Hi, Please tell me, how can I upload data from excel into SQL 2005 Thanks & regards, Ambrish Srivastav

Answer Wiki

Thanks. We'll let you know when a new response is added.

Connect to SQL Server 2005 Database. Then from Object Explorer Window, right click on the database which you want to import table into. Select Tasks -> Import Data.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • rbriggs

    You might find this application useful.

    You can avoid problems with validation and set defaults for missing values:

    http://leansoftware.net/en-us/products/exceltodatabase.aspx

    Basically you create a template by selecting a table and fields, then paste the data into the Excel application, validate and send.

    Defaults values can be NULL, a value, or an Excel formula.

    You can create custom SQL too, for example if you have some records that need to be inserted and some that need to update, here is an example of the custom SQL idea:

    http://leansoftware.net/tabid/123/g/posts/m/23/Excel-MySQL–INSERT-or-UPDATE-Records.aspx#post23

    Only recently released & free to try.

     I am just hoping for feedback or suggestions you have for improvement.

    Thanks
    Richard

    30 pointsBadges:
    report
  • vembutech
    Connect to SQL Server 2005 Database. Then from Object Explorer Window, right click on the database which you want to import table into. Select Tasks -> Import Data.
    1,765 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following