run Import and Export Data wizard in the Microsoft SQL Server program groupselect the destination as Excel format
不行,试过了,这个<long text>会出错。
then you probably need to use ADO GetChunk method to manually retrieve the data into EXCEL using automations or export the data into csv file format
找到了一个好方法用语句查询,然后ctrl+c打开excel ctrl+v谢谢你。给分。
使用ADO GetChunk/AppendChunk 读写SQL Server BLOB字段 http://www.ccw.com.cn/htm/app/aprog/01_8_31_4.aspHOWTO: Read and Write BLOBs Using GetChunk and AppendChunk http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q194975&
http://www.ccw.com.cn/htm/app/aprog/01_8_31_4.aspHOWTO: Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q194975&