Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Export data from Excel to ms sql

Posted on 2013-01-18
4
399 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook Free & Paid Tools
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

808 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