/// <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();
}
/// 使用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();
}