using (OleDbConnection oleConn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='С:\Temp\Example.xls';Extended Properties=Excel 8.0;"))
                    {
                        oleConn.Open();
                        OleDbCommand oleCmd = new OleDbCommand(@"Select * from OPENDATASOURCE('SQLOLEDB', 'data source=MyServer;initial catalog=MyDB;Trusted_Connection=yes').MyDB.dbo.MyTable", oleConn);
                        OleDbDataAdapter oleDa = new OleDbDataAdapter(oleCmd);
                        DataTable oleDt = new DataTable();
                        oleDa.Fill(oleDt);
                    } 

"Select * from OPENDATASOURCE('SQLOLEDB', 'data source=MyServer;initial catalog=MyDB;Trusted_Connection=yes').MyDB.dbo.MyTable"

Select * from [Лист1$]