Groups > comp.databases.ms-sqlserver > #1803

Importing Excel data, including relationships

Newsgroups	comp.databases.ms-sqlserver
Date	2014-08-26 10:24 -0700
Message-ID	<1a728b60-1e59-45b0-972f-71a1fc9d3ff4@googlegroups.com> (permalink)
Subject	Importing Excel data, including relationships
From	Monsieur Finkleberry <dtholen@gmail.com>

Show all headers | View raw

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?

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Importing Excel data, including relationships Monsieur Finkleberry <dtholen@gmail.com> - 2014-08-26 10:24 -0700

csiph-web