Excel file located on sharepoint. I would like to read excel file data into MS SQL DB without downloading Excel file

Dec 13 2011 12:42 PM

Hi, I have an test1.xlsx file located on http://sharepoint.xyz.com/sites/abc/test1.xlsx. can you please tell me how do I extract the data from this excel file into my local MS SQL DB without downloading this file. I am using SSIS.