Hi Koen,

Was missing just that! Thanks a ton!

Went to registry and updated TypeGuessRows to 0; only this time @HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel.

And the dataflow worked just fine. However, there could be a potential downside to this solution if the excel is too big.

Regards,

Palash.