How to insert data from one excel to another? I am using query "insert into [Tracking$$] ([Customer ID Number],[Company code],[Portal]) values ('$strCustomerID$','$strCompanyCode$','$strPortal$')". it is not working and also not throwing any error.

Hi @Ashwin A.K​ and @ChanduMohammad S​ ,

Yes, It is working now. Thank you so much for your help.

Welcome @Poonam Pandire​ 

Hi @Poonam Pandire​ ,

That's great!

Could you please explain how you resolved it?

It will benefit the community and help anyone facing similar issues.

Kind Regards,

Ashwin A.K

Hi @Ashwin A.K​ ,

I deleted old file and created new excel and it worked. Don't know why query was not working on old file.

Then the file might have been corrupted.

Anyway, thank you for sharing the solution here with us, we appreciate it.

Kind Regards,

Ashwin A.K