SQL数据导出成EXCEL表!!
SQL2005里面怎么将数据库里的数据导出成EXCEL表?没有现成的EXCEL表放数据~
郁闷了!2000和2005差别好大啊!

------解决方案--------------------
没用过帮顶
------解决方案--------------------
在数据库上直接点右键选导出,就行了.
------解决方案--------------------
对要导出数据库点右键,有个 "导出数据 ",然后根据向导一步步的做啊。

------解决方案--------------------
将DataGrid导出excel

protected System.Web.UI.WebControls.Button Submit;
protected System.Web.UI.WebControls.DataGrid ExList;


private void Submit_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.Buffer= true;
Response.Charset= "GB2312 ";
Response.AppendHeader( "Content-Disposition ", "attachment;filename=FileName.xls ");
Response.ContentEncoding=System.Text.Encoding.GetEncoding( "GB2312 ");//设置输出流为简体中文
Response.ContentType = "application/ms-excel ";//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo( "ZH-CN ",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.ExList.RenderControl(oHtmlTextWriter); //ExList 为DataList ID名称
Response.Write(oStringWriter.ToString());
Response.End();
}
------解决方案--------------------
可以使用,我用过的.
------解决方案--------------------
学习
------解决方案--------------------
没用过 帮顶

------解决方案--------------------
保存为csv文件，在页面上放个a链节，href=csv文件的链接地址——

public void Write_csv_svcid(DataTable dt, ref string csvName)
{
if(dt.Rows.Count != 0)
{
string tmp_path = HttpContext.Current.Server.MapPath( "buf ");
string filename = "app "+Guid.NewGuid().ToString() + ".csv ";
StreamWriter sw = new StreamWriter(tmp_path + "\\ " + filename, false, Encoding.Default);
sw.WriteLine( "推广业务,合作渠道,日期,入口用户数,入口访问数 ");
for(int i = 0; i < dt.Rows.Count; i++)
{
string str = " ";
str += dt.Rows[i][ "channel "].ToString() + ", ";
str += dt.Rows[i][ "DateStat "].ToString() + ", ";
str += dt.Rows[i][ "viewusers "].ToString() + ", ";
str += dt.Rows[i][ "views "].ToString();
sw.WriteLine(str);
}
sw.Flush();
sw.Close();
csvName = filename;
}
}
------解决方案--------------------
csv文件到客户端就可以直接用excel打开或保存
------解决方案--------------------
直接导出应该就可以了!
------解决方案--------------------
先建立一个空的excel表，然后再往这个表里导入数据