如何导出成CSV文件!!!!!!!

Question

如何用ASP代码来实现把数据从ACCESS数据库导出成CSV格式的文件!!!!
急啊!!!!!!!!!!!!!!!!!!!!!

Answer 1

http://blog.csdn.net/lovecherry/archive/2005/03/12/317790.aspx

Answer 2

先将数据导入datagrid，再导出csv文件SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
   SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
   DataSet ds=new DataSet();
   da.Fill(ds,"table1");
   DataTable dt=ds.Tables["table1"];
   StringWriter sw=new StringWriter();
   sw.WriteLine("自动编号,姓名,年龄");
   foreach(DataRow dr in dt.Rows)
   {
    sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
   }
   sw.Close();
   Response.AddHeader("Content-Disposition", "attachment; filename=test.csv");
   Response.ContentType = "application/ms-excel";
   Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
   Response.Write(sw);
   Response.End();