Dear All,
I have two excel files which I am opening using OLEDB.
I want to put filter at a column [INPUT]=@ and copy the datas from Column B,C,D,E ,F from the source excel sheet to another excel sheet B,C,D,E
How to write the Insert statement . Is it something like this below.
"INSERT INTO [Sheet1$] ([A],,[C],[D],[E])VALUES([Output.A]&"",[Output.B]&"",[Output.C],[Output.D],[Output.E])"
where Sheet1 is the name of my destination sheet where data will be pasted.
Source Excel Sheet
Destination Sheet
------------------------------
Marina Dutta
------------------------------
I have two excel files which I am opening using OLEDB.
I want to put filter at a column [INPUT]=@ and copy the datas from Column B,C,D,E ,F from the source excel sheet to another excel sheet B,C,D,E
How to write the Insert statement . Is it something like this below.
"INSERT INTO [Sheet1$] ([A],,[C],[D],[E])VALUES([Output.A]&"",[Output.B]&"",[Output.C],[Output.D],[Output.E])"
where Sheet1 is the name of my destination sheet where data will be pasted.
Source Excel Sheet
Destination Sheet------------------------------
Marina Dutta
------------------------------
