Hi Bitbucket,

Thanks for the help,

as i am using SSIS i am not specifically writing the OpenRowset -do you have any example for creating the dynamic connection to excel 2007 file...