Solved

Excel 2007/2010 to Sql 2008

Posted on 2011-09-23
4
403 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 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

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…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

717 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