在SQLSERVER里用SELECT INTO导出DBF,XLS表的问题!! 另外SQLSERVER里有没有实现这样功能的存储过程???? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这里没人知道么??? 高人帮帮忙吧。我在http://www.developersdex.com/sql/ 老外说对SQLSERVER里的DTS编程就可以做到。哪位高人做过DTS编程??? 我到是找到一个DTS编程的例子,是VB的,可是感觉帮助还是少。哪位做过的?请给点帮助吧????!!!!! 多谢了。可以加分。 导出好像是要用到ODBC莱连接,就向ASP导出SQL server一样,请参考. 可以試著寫點CODE Dim scriptt As New Scripting.FileSystemObject Dim tstrSave As TextStream Dim strFileName As String cmd1.ShowSave strFileName = cmd1.FileName Set scriptt = CreateObject("Scripting.FileSystemObject", sunny) Set tstrSave = scriptt.OpenTextFile(strFileName, ForWriting, True, TristateFalse) strhead = "工號" + Chr(9) + "姓名" + Chr(9) + "部門" + Chr(9) + "事假" + Chr(9) + "病假" + Chr(9) + "喪假" + Chr(9) + "礦工" + Chr(9) + "婚假" + Chr(9) + "公假" + Chr(9) + "工傷" & _ Chr(9) + "產假" + Chr(9) + "其他" + Chr(9) + "起止日期"(相關字段) tstrSave.Write strhead + Chr(13) For I = 0 To rs.RecordCount - 1 strt = rs.Fields("employeeid") + Chr(9) + rs.Fields("name") + Chr(9) + rs.Fields("department") + Chr(9) + Str(rs.Fields("accidenthols")) + Chr(9) & _ Str(rs.Fields("illhols")) + Chr(9) + Str(rs.Fields("diehols")) + Chr(9) + Str(rs.Fields("miner")) + Chr(9) + Str(rs.Fields("marriagehols")) & _ Chr(9) + Str(rs.Fields("commhols")) + Chr(9) + Str(rs.Fields("compohols")) + Chr(9) + Str(rs.Fields("newbabyhols")) + Chr(9) + Str(rs.Fields("othershols")) & _ Chr(9) + CStr(rs.Fields("starttime")) + "--" + CStr(rs.Fields("endtime")) tstrSave.Write strt + Chr(13) rs.MoveNext Next I tstrSave.Close 有用过SSDBGrid的没 想让vb在多个时间点执行我的程序、发送到多个地址 要怎么写? 高手请进!!!!问题解决不了...在线等!!!! 数据库备份到本地的问题 如何将16进制的字符串转换为16进制或者是long型? VB 的类模块怎么写落!我是菜鸟!有分拿啊! 在vb 的编程中, 因为要连接到sql ,所以要在 工具箱中建立datagird 等控件 socket紧急问题,技术经理问我的问题,紧急 如何将查询到的记录放入DBGIRD表中!?? 我如何以任意角度旋转一幅图片? 初次见面﹐一个小小的怪问题﹐不成敬意﹗ 关于某些WIN32 API 函数的应用!!!!
我在http://www.developersdex.com/sql/ 老外说对SQLSERVER里的DTS编程就可以做到。
哪位高人做过DTS编程??? 我到是找到一个DTS编程的例子,是VB的,可是感觉帮助还是
少。哪位做过的?请给点帮助吧????!!!!! 多谢了。
可以加分。
Dim scriptt As New Scripting.FileSystemObject
Dim tstrSave As TextStream
Dim strFileName As String
cmd1.ShowSave
strFileName = cmd1.FileName
Set scriptt = CreateObject("Scripting.FileSystemObject", sunny)
Set tstrSave = scriptt.OpenTextFile(strFileName, ForWriting, True, TristateFalse)
strhead = "工號" + Chr(9) + "姓名" + Chr(9) + "部門" + Chr(9) + "事假" + Chr(9) + "病假" + Chr(9) + "喪假" + Chr(9) + "礦工" + Chr(9) + "婚假" + Chr(9) + "公假" + Chr(9) + "工傷" & _
Chr(9) + "產假" + Chr(9) + "其他" + Chr(9) + "起止日期"(相關字段)
tstrSave.Write strhead + Chr(13)
For I = 0 To rs.RecordCount - 1
strt = rs.Fields("employeeid") + Chr(9) + rs.Fields("name") + Chr(9) + rs.Fields("department") + Chr(9) + Str(rs.Fields("accidenthols")) + Chr(9) & _
Str(rs.Fields("illhols")) + Chr(9) + Str(rs.Fields("diehols")) + Chr(9) + Str(rs.Fields("miner")) + Chr(9) + Str(rs.Fields("marriagehols")) & _
Chr(9) + Str(rs.Fields("commhols")) + Chr(9) + Str(rs.Fields("compohols")) + Chr(9) + Str(rs.Fields("newbabyhols")) + Chr(9) + Str(rs.Fields("othershols")) & _
Chr(9) + CStr(rs.Fields("starttime")) + "--" + CStr(rs.Fields("endtime"))
tstrSave.Write strt + Chr(13)
rs.MoveNext
Next I
tstrSave.Close