access转sqlite3，要注意32位和64位，下32位的，并且把驱动放到debug里面

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

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=bibleNosound.dat;Persist Security Info=True;Jet OLEDB:Database Password=pasitoldata"))
            {
                using (OleDbCommand cmd = new OleDbCommand("select * from bible, bibleid where bible.VolumeSN = bibleid.SN", con))
                {
                    con.Open();
                    using (OleDbDataReader sdr = cmd.ExecuteReader())
                    {
                        using (SQLiteConnection con2 = new SQLiteConnection("Data Source=hb2.sqlite3"))
                        {
                            con2.Open();
                            while (sdr.Read())
                            {
                                using (SQLiteCommand cmd2 = new SQLiteCommand("insert into t_hb (juan, jianxie, zhang, jie, jingwen) values (@juan, @jianxie, @zhang, @jie, @jingwen) ", con2))
                                {
                                    cmd2.Parameters.AddWithValue("juan", sdr["FullName"]);
                                    cmd2.Parameters.AddWithValue("jianxie", sdr["ShortName"]);
                                    cmd2.Parameters.AddWithValue("zhang", sdr["ChapterSN"]);
                                    cmd2.Parameters.AddWithValue("jie", sdr["VerseSN"]);
                                    cmd2.Parameters.AddWithValue("jingwen", sdr["strjw"]);
                                    cmd2.ExecuteNonQuery();
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}