Solved

Export data from Excel to ms sql

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

813 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

14 Experts available now in Live!

Get 1:1 Help Now