Hi Manojith,
Thanks for this piece of code.But again i have some doubts so i thought i will clear with you.
1.The syntax. "SELECT * FROM [TEST_01_UC01$] "but i am getting error on this.I am not sure if the name given is correct.
2.Actually the excel sheet name is check.xls and the database is also the same.Can you please advise me on this.
Rgds
Thushar
Thanks for this piece of code.But again i have some doubts so i thought i will clear with you.
1.The syntax. "SELECT * FROM [TEST_01_UC01$] "but i am getting error on this.I am not sure if the name given is correct.
2.Actually the excel sheet name is check.xls and the database is also the same.Can you please advise me on this.
Rgds
Thushar