How to import data to excel sheet

• sushma.patle

  SSC Veteran

  Points: 231

  More actions

  June 23, 2008 at 2:18 am

  #122267

  Dear Friend ,

  My problem is this i have a spread sheet with data ,

  now i want to import this data in data base,

  problem is that in my spread sheet suppose i have a column Employee name value like this

  Employee

  -----------

  Ram

  John

  Ram

  Ram

  Shalu

  John

  now when i import this data in my sql server table then output i want like that

  Employee id Employee Name

  -----------------------------------

  1 Ram

  2 John

  3 Shalu

  so how i use condition on spread sheet or what is the other option to do like this becoz when i use simple ssis package to import data from excel file to sql then data is insert one by one and i am not find where i put condition so what i do for this.

  Thanks in advance 🙂

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  June 23, 2008 at 2:37 am

  #832508

  If you are using SQL Server 2005 ,

  import using wizard and there is one option "write query to specify the data transfer" use that.:)