access移植到SQL server经文

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data.OleDb;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=bibleNosound.mdb;"))
            {
                using (OleDbCommand cmd = new OleDbCommand("SELECT fullname, shortname, py, chaptersn, versesn, strjw from bibleid,bible where bibleid.sn = bible.Volumesn", conn))
                {
                    conn.Open();
                    using (OleDbDataReader odr = cmd.ExecuteReader())
                    {
                        while (odr.Read())
                        {
                            using (SqlConnection conn2 = new SqlConnection("server=.;database=hb;user id=sa;password=a"))
                            {
                                using (SqlCommand cmd2 = new SqlCommand("insert into t_hb (juanming, suoxie, pinyin, zhang, jie, jingwen) values (@juanming, @suoxie, @pinyin, @zhang, @jie, @jingwen)", conn2))
                                {
                                    cmd2.Parameters.AddWithValue("juanming", odr["fullname"]);
                                    cmd2.Parameters.AddWithValue("suoxie", odr["shortname"]);
                                    cmd2.Parameters.AddWithValue("pinyin", odr["py"]);
                                    cmd2.Parameters.AddWithValue("zhang", odr["chaptersn"]);
                                    cmd2.Parameters.AddWithValue("jie", odr["versesn"]);
                                    cmd2.Parameters.AddWithValue("jingwen", odr["strjw"]);
                                    conn2.Open();
                                    cmd2.ExecuteNonQuery();
                                    Console.WriteLine(odr["fullname"].ToString());
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}