I have a requirement is that need to load excel sheet from share point can any one help me out.
In that excel sheet i have around 5 sheets.
Try like Below:
Let vSharePointPath = 'http://mydocuements/sharepoint/'; // Get full folder path
FROM [$(vSharePointPath)/ExceFileName1.xls] (ooxmal) (sheet$1);
Retrieving data ...