Solved

Export data from Excel to ms sql

Posted on 2013-01-18
4
404 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
[X]
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
  • 2
4 Comments
 
LVL 8

Accepted Solution

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

Expert Comment

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

Assisted Solution

by:Eugene Z
Eugene Z 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 …

730 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