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

Software/Hardware used:
Sql server2005 and Ms excel 2007
ASKED: October 29, 2009  11:04 AM
UPDATED: August 10, 2010  1:34 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  October 29, 2009  9:52 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

How do you create a user control in Excel to export the excel data to sql?

Marine88
 10 pts.
 

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

MelanieYarbrough
 6,315 pts.