Thursday 24 July 2014

Import excel file and insert data to sql

              Import excel file and insert data to sql



step 1- simply import excel file 
step 2- change datatype in table which is import in sql
step 3- create table in sql with same column 
step 4- Copy data from given below query 
## note here ProductMaster$ imported file from excel
## note here ProductMST table where data copied

insert into ProductMST(Market_Sec,Product_hi,Product_Gr,Product_Sub_Group,Material,Description,Category,CreateBy,CreatedDate,CreatedClientIP,ModifiedBy,ModifiedDate,ModifiedClientIP,Status)
select TCPR.Market_Sec,TCPR.Product_hi,TCPR.Product_Gr,TCPR.Product_Sub_Group,TCPR.Material,TCPR.Description,TCPR.Category,TCPR.CreateBy,TCPR.CreatedDate,TCPR.CreatedClientIP,TCPR.ModifiedBy,TCPR.ModifiedDate,TCPR.ModifiedClientIP,TCPR.Status
 from ProductMaster$ TCPR