把EXCEL中的表结构及数据放到Access数据库中

  /// <summary>
        /// 使用SQL语句把Excel中的表结构及数据放到Access数据库中
        /// </summary>
        /// <param name="tableName">表名</param>
        private void ExecuteExcelDataToAccess(string tableName)
        {
            m_OleDbcommand.CommandText = string.Format(@"SELECT * INTO [MS Access;Database={0}].{1} FROM [{1}$]",
            m_AccessDataBasePath, tableName);
            m_OleDbcommand.ExecuteNonQuery();
        }