http://letmegooglethatforyou.com/?q=.net+oledb+excel

:-)

>Well that's wonderful!!!
>
>So post the code so we'll all know how!!
>
>
>
>>Gentleman,
>>I think both of your solutions create a dependency for Excel to be installed on the machine. I've read data in from Excel using an OleDbConnection with good success, and no dependencies required.
>>
>>>Here's what I've used before:
>>>
>>>

>>>using System;
>>>using System.Data;
>>>using System.Net.Mime;
>>>using Microsoft.Office.Interop.Excel;
>>>using System.Text;
>>>using System.Reflection;
>>>
>>>namespace ConsoleApplication3
>>>{
>>>    public class ExcelWrapper
>>>    {
>>>        public DataSet GetExcel(string fileName)
>>>        {
>>>            //
>>>            //  Include a reference to Microsoft.Office.Interop.Excel
>>>            //  ExcelWrapper wrap = new ExcelWrapper();
>>>            //  DataSet ds = wrap.GetExcel(@"c:\development\rda.xls");
>>>            //
>>>            //  I just ran this against an old spreadsheet an it worked fine.
>>>            //
>>>
>>>            Application oXL;
>>>            Workbook oWB;
>>>            Worksheet oSheet;
>>>            Range oRng;
>>>            try
>>>            {
>>>                //  creat a Application object
>>>                oXL = new ApplicationClass();
>>>                //   get   WorkBook  object
>>>                oWB = oXL.Workbooks.Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
>>>                        Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
>>>                        Missing.Value, Missing.Value);
>>>
>>>                //   get   WorkSheet object 
>>>                oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Sheets[1];
>>>                System.Data.DataTable dt = new System.Data.DataTable("dtExcel");
>>>                DataSet ds = new DataSet();
>>>                ds.Tables.Add(dt);
>>>                DataRow dr;
>>>
>>>                StringBuilder sb = new StringBuilder();
>>>                int jValue = oSheet.UsedRange.Cells.Columns.Count;
>>>                int iValue = oSheet.UsedRange.Cells.Rows.Count;
>>>                //  get data columns
>>>                for (int j = 1; j <= jValue; j++)
>>>                {
>>>                    dt.Columns.Add("column" + j, System.Type.GetType("System.String"));
>>>                }
>>>
>>>                //string colString = sb.ToString().Trim();
>>>                //string[] colArray = colString.Split(':');
>>>
>>>                //  get data in cell
>>>                for (int i = 1; i <= iValue; i++)
>>>                {
>>>                    dr = ds.Tables["dtExcel"].NewRow();
>>>                    for (int j = 1; j <= jValue; j++)
>>>                    {
>>>                        oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
>>>                        string strValue = oRng.Text.ToString();
>>>                        dr["column" + j] = strValue;
>>>                    }
>>>                    ds.Tables["dtExcel"].Rows.Add(dr);
>>>                }
>>>                return ds;
>>>            }
>>>            catch (Exception ex)
>>>            {
>>>                throw;
>>>            }
>>>        }
>>>    }
>>>}
>>>