Hi,
I embedded the datasource in single quotes as below. It's worked for me.
FileName = FileName.Replace("'", "''");
string OledbCon = @"Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + FileName.Trim() + "';" + "Extended Properties=Excel 12.0;";