文本导入Access中数字0没了

Question

OleDbDataAdapter oda = new OleDbDataAdapter();
DataSet ds = new DataSet();
oda.SelectCommand = new OleDbCommand("Insert INTO Data Select F1 as Data0 FROM [TEXT;HDR=NO;FMT=Delimited(); IMEX=1;DATABASE=E:].01.txt", connbase);
oda.Fill(ds, "Data");

Answer 1

当成数字了

如果你可以修改txt，你可以加上引号
"0001"
"0002"
...
这样。

或者你可以自己写一个程序导入
var data = File.ReadAllLines("1.txt");
OledbCommand cmd = new OledbCommand("", connbase);
foreach (var l in data)
{
cmd.CommandText = "insert into Data set Data0 = '" + l + "'");
cmd.ExecuteNoQuery();
}