ACCESS导表及数据

在项目中用到了导ACCESS表数据及结构。于是有了下文：

Code
 1 /**//// <summary>
 2        /// 将原库所有表数据导入目标库中所有同名表中
 3        /// </summary>
 4        /// <param name="DesFileName">目标库文件</param>
 5        /// <param name="ResFileName">原库文件</param>
 6        private static void ExpoData(string DesFileName, string ResFileName)
 7        {
 8            DBA db = new DBA(DesFileName, false);
 9            using (db)
            {
                //get all table name
                string ConnectionString = @"Provider=Microsoft.Jet.OleDB.4.0;Data Source=" + ResFileName;
                OleDbConnection conn = new OleDbConnection(ConnectionString);
                conn.Open();
                DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
                                                            new object[] { null, null, null, "TABLE" });
                foreach (DataRow dr in schemaTable.Rows)
                {
                    //表名
                    MessageBox.Show(dr["TABLE_NAME"].ToString());

                    //字段名
                    DataTable columnTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,
                            new object[] { null, null, dr["TABLE_NAME"].ToString(), null });

                    foreach (DataRow dr2 in columnTable.Rows)
                    {
                        MessageBox.Show("{0}", dr2["COLUMN_NAME"].ToString());
                    }

                }
                conn.Close();

                if (0 == db.ExecuteNonQuery("select * into " + DesFileName + " from " + ResFileName))
                    MessageBox.Show("Export data successful");
                else
                    MessageBox.Show("Export data failed");
            }
        }