X-Received: by 10.66.119.174 with SMTP id kv14mr18821245pab.23.1409073844868; Tue, 26 Aug 2014 10:24:04 -0700 (PDT)
X-Received: by 10.140.95.7 with SMTP id h7mr541064qge.4.1409073844717; Tue, 26 Aug 2014 10:24:04 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!uq10no5401165igb.0!news-out.google.com!j6ni8038qas.0!nntp.google.com!m5no3344278qaj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Tue, 26 Aug 2014 10:24:04 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.85.121.235; posting-account=UgCWnAoAAAACN8zYTOYO1qhERixIGjRb
NNTP-Posting-Host: 178.85.121.235
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1a728b60-1e59-45b0-972f-71a1fc9d3ff4@googlegroups.com>
Subject: Importing Excel data, including relationships
From: Monsieur Finkleberry <dtholen@gmail.com>
Injection-Date: Tue, 26 Aug 2014 17:24:04 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1803

I have 2 tables:

ORDER
-------
Id:int


ORDERLINES
----------
Id:int
OrderId:int


I have exported these 2 tables to an Excel sheet (2 sheets in a file).

Now I need to import them into the new DB, which has a slightly different Order table, so some transformation is needed.

How can I import this into the DB? I have tried the wizard, bit too many "failed" conversions on fields.

Do I need to use SSIS?