Solved

how to copy excel spreadsheet data from an excel spreadsheet into a sql server database

Posted on 2014-12-11
3
108 Views
Last Modified: 2014-12-13
I have an excel spreadsheet and I want to copy that data into a sql server table. Either a new table created upon import, or a table I create prior to the import. Whichever is the best technique.

So how do I copy the data from the Excel Spreadsheet to a sql server database? I am using sql server 2008?
0
Comment
Question by:brgdotnet
[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
3 Comments
 
LVL 12

Accepted Solution

by:
James Elliott earned 250 total points
ID: 40495550
Right click on the database on the left hand side of your SSMS window, then select Tasks => Import Data.

From here you can select either MS Excel as the source, or connect via other more specific methods.
0
 
LVL 11

Assisted Solution

by:SThaya
SThaya earned 250 total points
ID: 40495584
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 40496119
A valid question here is 'Do you have any control over the source data being in Excel?'.

Excel is great in that users can do anything.  Excel is terrible as a source of normalized data in that users can do anything to mess up the formatting so it can't be consumed, causing applications like SSIS and SSRS that require a 'contract' mapping of Source and Destination in order to pump data.

The above SSIS link looks pretty comprehensive.  Would be worth spelling out some of that content in this question.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

632 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