有谁做个把Excel的数据转换到Access数据空中啊?
我想把Excel的数据通过WEB页面添加到Access数据库中,有谁有做个的,或是有好的建议和是提示的吗?
我现在的问题的,数据可以导入进去,但是只能显示数字类型的,字符串的什么都看不见~!有谁可以帮帮我啊~!我是有ASP.NET的~!
下面是我的代码~!有高手的请帮我看看~!
谢谢~!
private void Button1_Click(object sender, System.EventArgs e)
{
AccessConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("Message.mdb"));
ExcelConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 8.0;Data Source="+ File1.PostedFile.FileName);//File1.PostedFile.FileName要导入的Excel数据
OleDbCommand ExcelCmd = new OleDbCommand("SELECT * FROM [Sheet1$]",ExcelConn);
ExcelConn.Open();
OleDbDataReader ExcelDr = ExcelCmd.ExecuteReader();
OleDbCommand AccessCmd = new OleDbCommand("",AccessConn);
AccessConn.Open();
while(ExcelDr.Read())
{
AccessCmd.CommandText = "insert into username([names],[qq],[email],[http],[content]) values('"
+ fixsql(ExcelDr.GetValue(0)) + "','"
+ fixsql(ExcelDr.GetValue(1)) + "','"
+ fixsql(ExcelDr.GetValue(2)) + "','"
+ fixsql(ExcelDr.GetValue(3)) + "','"
+ fixsql(ExcelDr.GetValue(4)) + "')";
AccessCmd.ExecuteNonQuery(); }
AccessCmd.Dispose();
AccessConn.Close();
ExcelConn.Close();
AccessConn.Dispose();
ExcelConn.Dispose();
}
我想把Excel的数据通过WEB页面添加到Access数据库中,有谁有做个的,或是有好的建议和是提示的吗?
我现在的问题的,数据可以导入进去,但是只能显示数字类型的,字符串的什么都看不见~!有谁可以帮帮我啊~!我是有ASP.NET的~!
下面是我的代码~!有高手的请帮我看看~!
谢谢~!
private void Button1_Click(object sender, System.EventArgs e)
{
AccessConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("Message.mdb"));
ExcelConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 8.0;Data Source="+ File1.PostedFile.FileName);//File1.PostedFile.FileName要导入的Excel数据
OleDbCommand ExcelCmd = new OleDbCommand("SELECT * FROM [Sheet1$]",ExcelConn);
ExcelConn.Open();
OleDbDataReader ExcelDr = ExcelCmd.ExecuteReader();
OleDbCommand AccessCmd = new OleDbCommand("",AccessConn);
AccessConn.Open();
while(ExcelDr.Read())
{
AccessCmd.CommandText = "insert into username([names],[qq],[email],[http],[content]) values('"
+ fixsql(ExcelDr.GetValue(0)) + "','"
+ fixsql(ExcelDr.GetValue(1)) + "','"
+ fixsql(ExcelDr.GetValue(2)) + "','"
+ fixsql(ExcelDr.GetValue(3)) + "','"
+ fixsql(ExcelDr.GetValue(4)) + "')";
AccessCmd.ExecuteNonQuery(); }
AccessCmd.Dispose();
AccessConn.Close();
ExcelConn.Close();
AccessConn.Dispose();
ExcelConn.Dispose();
}
但是,只要那对应的是数字的话就能写到数据库中,这说明SQL没有错吧~!
我的问题就是不能把字符串写到数据库,准确的说是写进去看不见(因为写数据的时候没有错误~!)