c# 读取ACCESS 数据库

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {

            FileStream fs = new FileStream("ak-1.csv", FileMode.Create);

            OleDbConnection conn = null;
            OleDbDataReader reader = null;
            conn = new OleDbConnection(
            "Provider=Microsoft.Jet.OLEDB.4.0; " +
            "Data Source=" + ("C:/Users/Ali/Documents/aaaaa.mdb"));
            conn.Open();
            OleDbCommand cmd =
                new OleDbCommand("Select * FROM 用户信息", conn);
            reader = cmd.ExecuteReader();
            int count = 0;
            while (reader.Read())
            {
                count++;
                if (count % 50000 == 0)
                {
                    fs = new FileStream("ak-"+(count/50000+1)+".csv", FileMode.Create);
                }

                String x = getsss(reader, 0) + "," + getsss(reader, 1) + "," +
                getsss(reader, 2) + "," + getsss(reader, 3) + "," +
                getsss(reader, 4) + "," + getsss(reader, 5) + "," +
                getsss(reader, 6) + "," + getsss(reader, 7) + "," +
                getsss(reader, 8) + "," + getsss(reader, 9)+"\r\n";
                    //Console.WriteLine(x);
                
                



                byte[] aaaaa = System.Text.Encoding.Default.GetBytes(x);
                //reader.Read();
                //Console.WriteLine(reader.GetString(2));
                fs.Write(aaaaa,0,aaaaa.Length);
                fs.Flush();


            }
            fs.Close();
            





        }


        private static String getsss(OleDbDataReader reader,int a) {

        try
        {
                return reader.GetString(a);

        }
        catch (Exception e)
        {
                return "";
                
            }
            


            

        }

    }


    




}

 

转载于:https://www.cnblogs.com/aliblogs/p/6142134.html