Reading Excel to Access

See more:

C#

Hi, im trying to develop an application which can convert Excel worksheet to an Access db. im new for software development. Im unable to fix the below errors and would be grateful if somebody can help me to figure out the solution. thanks in advance

errors that were generated given below:

1. The best overloaded method match for Acess._Application.Quit(Access.AcQuitOption)' has some invalid arguments

2. Argument '1': cannot convert from 'Microsoft.Office.Interop.Access.AcQuitOption' to 'Access.AcQuitOption'

3. No overload for method 'FillAccessDatabase' takes '1' arguments

here is the code that i use:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;

namespace WindowsFormsApplication2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

        }

        public static void CheckUpdateDBFile(string filename)
        {
            
            if (File.Exists(@"C:\Book.mdb"))
            {

                File.Delete(@"C:\Book.mdb");

            }

            Access.Application _accessData;

            _accessData = new Access.ApplicationClass();

            _accessData.Visible = false;

            _accessData.NewCurrentDatabase(@"C:\Book.mdb");

            _accessData.CloseCurrentDatabase();

            _accessData.Quit(Microsoft.Office.Interop.Access.AcQuitOption.acQuitSaveAll);

            _accessData = null;

            OleDbConnection _connection = MakeExcelConnection(filename);

            FillAccessDatabase(_connection);

        }

        private static OleDbConnection MakeExcelConnection(string fileName)
        {

            string _filename = @"C:\NMS_List_Export.xls";

            string _conn;

            _conn = "Provider=Microsoft.Jet.OLEDB.12.0;" + @"Data Source=" + _fileName + ";" +

            "Extended Properties=Excel 12.0;";
            OleDbConnection _connection = new OleDbConnection(_conn);

            return _connection;
        }

        public static void FillAccessDatabase()
        {
            OleDbCommand _command = new OleDbCommand();

            _command.Connection = _connection;

            try
            {

                _command.CommandText = @"SELECT * INTO [MS Access;Database=C:\Book.mdb].[NMS_List_Export] FROM [NMS_List_Export$]";

                _connection.Open();

                _command.ExecuteNonQuery();

                _connection.Close();

                MessageBox.Show("The import is complete!");

            }

            catch (Exception)
            {

                MessageBox.Show("Import Failed, correct Column name in the sheet!");
            }
        }

    }
}