Home > IT Answers > Microsoft Windows > How to export excel data to Sql server 2005
Rasheed180207
5 pts.
Q:
How to export excel data to Sql server 2005
Excel 2007, Exporting Excel to SQL, SQL Server 2005, Microsoft Excel
How to export excel data to Sql server 2005

Software/Hardware used:
Sql server2005 and Ms excel 2007
ASKED: Oct 29 2009  11:04 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
49385 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
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.
Last Answered: Oct 29 2009  9:52 PM GMT by Mrdenny   49385 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _