Solved

Excel 2007/2010 to Sql 2008

Posted on 2011-09-23
4
394 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
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
MuffyBunny earned 500 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

759 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

20 Experts available now in Live!

Get 1:1 Help Now