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
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home