Sunday, 27 December 2015

How to club the Data when Data Located in Different Tabs of Excel



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