SQLTeam.com | Weblogs | Forums

How to parse Excel 95 (.xls) file

Hi Guys,
I have an Excel 95 (.xls) file. Client can't provide the excel file in a different format. I am using SSIS Excel source and Scrip task but no help. Every time I am getting different results. However, if I open the file and save it to .xls ( Excel 97-2003) it working without any problem. I want to automate this process. Any advice would be great appreciated.