How to export excel data to Sql server 2005

5 pts.
Tags:
Excel 2007
Microsoft Excel
SQL Server 2005
How to export excel data to Sql server 2005

Software/Hardware used:
Sql server2005 and Ms excel 2007

Answer Wiki

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

SQL Server has an Import Wizard. You’ll need to install the SQL Server Management Studio on your computer. After you do (it is available on the SQL Server CD/DVD) connect to the SQL Server. In the object explorer window, right click on the database you want to import the database into, select the tasks menu option, then the Import data option. This will present you with a wizard you can run though which will guide you through importing the data into the SQL Server database.

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
  • Marine88
    How do you create a user control in Excel to export the excel data to sql?
    10 pointsBadges:
    report
  • MelanieYarbrough
    Hi Marine88, Please start a new thread for your question to ensure you get a thorough and quicker response. Please include details as to what versions of each program, application or server you're using. Thank you! - Melanie
    6,345 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