C# and excel: Reading excel files into MS SqlServer.

using System;

using System.Runtime.InteropServices;

using Excel = Microsoft.Office.Interop.Excel;

namespace cmExcelEngine

  public class ExcelEngine

    private System.Object missingValue = System.Reflection.Missing.Value;

    private const int cA = 1;

    // thru cZ = 26;  as required

    private Excel.Application excelApp = null;

    private Excel.Workbook excelWorkbook = null;

    private Excel.Sheets excelSheets = null;

    private Excel.Worksheet excelWorksheet = null;

    private Excel.Workbooks excelWorkbooks = null;

    public ExcelEngine()

      string cd = System.Environment.CurrentDirectory;

      excelApp = new Excel.ApplicationClass();

      // Open an Excel template, create a new "document"

      excelApp.Workbooks.Add(cd + "\\template.xlt");

      // or load a file of your choosing
      //excelApp.Workbooks.Open(cd + "\\template.xlt", false, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t",

      // true, false, null, false, null, false);

  public void Show()

    excelApp.Visible = true;

  public Excel.Worksheet SelectSheet(string sheetName)

    Excel.Worksheet returnSheet = null;

    foreach(Excel.Worksheet workSheet in excelWorkbook.Worksheets)

      if (workSheet.Name == sheetName)

    return returnSheet;

  // Read/Write to/from the Excel sheet...
  public void PopulateSummary;

    public void Quit()

      excelWorkbook.Close(false, missingValue, missingValue);

      Marshal.ReleaseComObject(excelWorksheet);

      Marshal.ReleaseComObject(excelSheets);

      Marshal.ReleaseComObject(excelWorkbooks);

      Marshal.ReleaseComObject(excelWorkbook);

      Marshal.ReleaseComObject(excelApp);

      excelWorksheet = null;

      excelSheets = null;

      excelWorkbooks = null;

      excelWorkbook = null;

      excelApp = null;

      GC.GetTotalMemory(false);

      GC.Collect();

      GC.WaitForPendingFinalizers();

      GC.Collect();

      GC.GetTotalMemory(true);

This example demonstrates how to open an Excel spreadsheet and populate it - but reading from the spreadsheet uses the same code:

SummaryCost =  excelWorksheet.Cells[17, cC];

Once you have got the Excel aspect working, post back here with some code/data examples...may be somebody will be able to help with your database question then...

HTH

??????