I have come a cross the requirement, where Different County's data located in different Tabs of single Excel workbook.
So I used the Custom SQL option ti get the data of all sheets.
I have written the following SQL Query,
select * from [Country A$]
Union all
select * from [Country B$]
Union all
select * from [Country C$]
No comments :
Post a Comment