Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1803
| 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> (permalink) |
| 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 |
Show key headers only | 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
Importing Excel data, including relationships Monsieur Finkleberry <dtholen@gmail.com> - 2014-08-26 10:24 -0700
csiph-web