?
Solved

Excel 2007/2010 to Sql 2008

Posted on 2011-09-23
4
Medium Priority
?
404 Views
Last Modified: 2012-05-12
If I have a column in excel called contract no, and a table in sql 2008 called plantname_usa_inc, with a column in it called contract_information_contract.

What is the best way to import the data from the excel column to the sql column??

Thanks!!
0
Comment
Question by:HDM
[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
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
MuffyBunny earned 2000 total points
ID: 36587479
There are a couple ways you can do this.

1. SSIS - most efficient and most complex
2. Create a staging table. Copy & Paste the data to that table and then write a script that gets the right pieces to the right spots.
0
 

Author Comment

by:HDM
ID: 36587921
If I use SSIS, what data source would I select??
0
 
LVL 6

Expert Comment

by:MuffyBunny
ID: 36588003
right-click in the connections area and choose New Connection...

One of the options in the list will be EXCEL. The rest of the file setup will be self-explanatory.
0
 

Author Comment

by:HDM
ID: 36588739
Problem I found is this:

x64 SQL hass no option for excel.

x32 has option but returns this:

TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

Could not find installable ISAM. (Microsoft JET Database Engine)

------------------------------
BUTTONS:

OK
------------------------------


I ended up importing excel to Access then upsizing the data to SQL.  Mission accomplished.

Thanks so much for your help!!  :-)

0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

764 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