C#

private DataTable GetExcel(string fileName, string sheetName)
	    {
            DataTable dt = new DataTable(sheetName);

	        try
	        {
                string ConStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";", fileName); 
                string Sql = "SELECT * FROM [" + sheetName + "$]";

	            OleDbConnection Conn = new OleDbConnection(ConStr);
                OleDbCommand Comm = new OleDbCommand(Sql, Conn);
	                
	            OleDbDataAdapter da = new OleDbDataAdapter(Comm);

                Process[] process;
                process = System.Diagnostics.Process.GetProcessesByName("Excel");
                if (process.Length > 0)
                {
                    process[0].Kill();
                }

	            Conn.Open(); 
	            da.Fill(dt);
	            Conn.Close();
	        }
	        catch (Exception ex)
	        {
	            Console.WriteLine(ex.ToString());
	        }
	 
	        return dt;
	    }

        private void GetExcelInfo()
        {
            string theFile = textBoxExcelFile.Text;
            string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + theFile + ";Extended Properties=Excel 8.0";
            string sheetName = "Sheet1";

            // Create the connection object
            OleDbConnection Conn = new OleDbConnection(ConStr);
            try
            {
                // Open connection
                Conn.Open();

                // Create OleDbCommand object and select data from worksheet Sheet1
                OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + sheetName + "$]", Conn);

                // Create new OleDbDataAdapter
                OleDbDataAdapter da = new OleDbDataAdapter(cmd);

                // Create a DataSet which will hold the data extracted from the worksheet.
                DataSet ds = new DataSet();

                // Fill the DataSet from the data extracted from the worksheet.
                da.Fill(ds);

                // Bind the data to the GridView
                dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                // Close connection
                Conn.Close();
            }

        }

Thank you of your help...Pat