using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data.OleDb;
using System.Web;
using System.Configuration;
using System.Data;
using System.Collections;
using System.Windows.Forms;
//using System.Data.ConnectionState;
namespace QuanLiDSSV
    public partial class Frm2 : Form

        public Frm2()


        private void btnBrowse_Click(object sender, EventArgs e)
            OpenFileDialog sh = new OpenFileDialog();
            sh.FileName = txtDuongDanFile.Text;
            if (sh.ShowDialog() == DialogResult.OK)
                txtDuongDanFile.Text = sh.FileName;
            //File Names, replae with your file names

            string fileNameExcel = @"e:\luan van\DSSV.xls";

            string fileNameAccess = @"e:\luan van\quanlythuhocphi.mdb";

            //Connection string for Excel

            string connectionStringExcel =

                string.Format("Data Source= {0};Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;", fileNameExcel);

            //Connection string for Access

            string ConnectionStringAccess =

                string.Format("Data Source= {0}; Provider=Microsoft.Jet.OLEDB.4.0; Persist security Info = false", fileNameAccess);

            //Connection object for Excel

            OleDbConnection connExcel = new OleDbConnection(connectionStringExcel);

            //Connection object for Access

            OleDbConnection connAccess = new OleDbConnection(ConnectionStringAccess);

            //Command object for Excel

            OleDbCommand cmdExcel = connExcel.CreateCommand();

            cmdExcel.CommandType = CommandType.Text;

            cmdExcel.CommandText = "SELECT * FROM [Sheet1$]";

            //Command object for Access

            OleDbCommand cmdAccess = connAccess.CreateCommand();

            cmdAccess.CommandType = CommandType.Text;

            cmdAccess.CommandText = "INSERT INTO quanlythuhocphi (MaSV, Ho, Ten, Nganh hoc, Khoa hoc) VALUES(@Mã SV, @Họ, @Tên, @Ngành học, @Khóa học)";

            //Add parameter to Access command object

            OleDbParameter param1 = new OleDbParameter("@Mã SV", OleDbType.VarChar);


            OleDbParameter param2 = new OleDbParameter("@Họ", OleDbType.VarChar);

            OleDbParameter param3 = new OleDbParameter("@Tên", OleDbType.VarChar);


            OleDbParameter param4 = new OleDbParameter("@Ngành học", OleDbType.VarChar);


            OleDbParameter param5 = new OleDbParameter("@Khóa học", OleDbType.Integer);


            //Open connections



            //Read Excel

            OleDbDataReader drExcel = cmdExcel.ExecuteReader();

            while (drExcel.Read())

                //Assign values to access command parameters

                param1.Value = drExcel[0].ToString();

                param2.Value = drExcel[1].ToString();

                param3.Value = drExcel[2].ToString();
                param4.Value = drExcel[3].ToString();
                param5.Value = drExcel[4].ToString();

                //Insert values in access



            //close connections





Have a error at "insert into" but i don't find.
Please help me!
Thank u!

Edited 3 Years Ago by mike_2000_17: Fixed formatting

Error is "Syntax error in INSERT INTO statement."
Please help me!

This article has been dead for over six months. Start a new discussion instead.