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 "";
}
}
}
}