Solved

Export data from Excel to ms sql

Posted on 2013-01-18
4
366 Views
Last Modified: 2013-01-21
Hi!

Have a Excel file, that i need to import into a ms sql table

How do i do this from excel ?
0
Comment
Question by:team2005
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
R_Edwards earned 350 total points
ID: 38792807
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38797447
what version edition of sql server? what version of your excel?
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 150 total points
ID: 38797448
Importing MS Excel data to SQL Server 2008
http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx

and just in case:

Exporting SQL Server Data to Excel (SQL Server Video)
http://msdn.microsoft.com/en-us/library/cc952922(v=sql.100).aspx
0
 
LVL 2

Author Closing Comment

by:team2005
ID: 38803209
thanks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now