I have excel with dynamic column and i want to load into table creating dynamic columns.
I need to add new columns in the same table
kindly suggest me the approch for the same
source excel -1
=========
Emp_Id No_Frame
source excel -2
=========
Emp_Id No_Frame No_Sales No_Month No_Purchase
like these, the source excel will have more / less columns. based on this, i need to insert into my database table
I willnot be able to use SP
select *
FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 8.0;Database
as my server doesnot allow to install any provider of MS 🙁