1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:

int betrag;
string art;
DateTime datum;
Boolean zv;

Excel.Application excelApplication;
Excel.Workbook excelWoorkbook;
Excel.Worksheet excelWoorksheet;
Excel.Range excelRange;

excelApplication = new Excel.Application();
excelApplication.Visible = false;

string appPath = Path.GetDirectoryName(Assembly.GetEntryAssembly().Location);
string filename = Path.Combine(appPath, @"C:\Geld.iqy");

excelWoorkbook = excelApplication.Workbooks.Open(filename);
excelWoorksheet = excelWoorkbook.Worksheets[1];
excelRange = excelWoorksheet.UsedRange;

// habe ich von der Seite :)
int rCnt = 0;        
for (rCnt = 1; rCnt <= excelRange .Rows.Count; rCnt++)
        {
            
            if ((range.Cells[rCnt, 1] as Excel.Range).Value2 != null)
            {
                try
                {
                   betrag = (range.Cells[rCnt, 1] as Excel.Range).Value2;
                   art = (range.Cells[rCnt, 2] as Excel.Range).Value2;
                   datum = (range.Cells[rCnt, 3] as Excel.Range).Value2;
                   zv = (range.Cells[rCnt, 4] as Excel.Range).Value2;
                 }
              }
         }
string anweisung = String.Format("INSERT INTO Daten" +
                            "(Betrag,Art,Datum, ZV)  Values" +
                            "('{0}','{1}','{2}','{3}')", betrag, art, datum, zv);
                        SqlCommand cmd = new SqlCommand(anweisung, Con);
                        cmd.ExecuteNonQuery();