... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 19,101 of 19,505

Monsieur Finkleberry to All

Importing Excel data, including relation

26 Aug 14 10:24:04

   From: dtholen@gmail.com   
      
   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?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]