C#把Acess数据库中的表全部导入到Sql库中

//sql服务信息   

public struct StructServerConfig
    {
        public string serverName;
        public string userName;
        public string password;
        public string dbType;
        public string dbFolderPath;
        public string serverType;
    }

 

 

        /// <summary>
        /// 根据mdb路径及数据库名，把Access数据导入到对应的Sql库中
        /// </summary>
        /// <param name="serverConfig"></param>
        /// <param name="filePath">Acess数据库mdb文件路径</param>
        /// <param name="dbName">sql库名</param>
        public bool ConvertAccess2Sql(StructServerConfig serverConfig, string filePath, string dbName)
        {

            private SqlConnection con = null;
            bool flag = true;
            try
            {

                string connString = "Data Source=" + serverConfig.serverName + ";Initial Catalog=master;User ID=" +
                                    serverConfig.userName + ";Password=" + serverConfig.password + ";DataBase =" &