(高手请进!)通过代码,调用SQL的导入/导出功能?(类似调用SQL的备份/恢复功能) 通过代码,调用SQL的导入/导出功能?(类似调用SQL的备份/恢复功能) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 利用SQLDMO实现带进度条的数据库备份: '?添加进度条ProgressBar1控件 '?引用Microsoft SQLDMO Object Library '声明 Public WithEvents bkps As SQLDMO.Backup '数据库备份操作 Private Sub btnBackUp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBackUp.Click Dim oSQLServer As New SQLDMO.SQLServer() oSQLServer.LoginSecure = False oSQLServer.Connect("(local)", "sa", "sa") '连接服务器 Me.Cursor = Windows.Forms.Cursors.WaitCursor bkps = CreateObject("SQLDMO.Backup") bkps.Database = "Northwind" '指定需备份的数据库 bkps.Action = 0 bkps.Files = "f:\Northwind.bak" '指定备份文件 bkps.Initialize = True ProgressBar1.Value = 0 ProgressBar1.Maximum = 100 Me.Cursor = Windows.Forms.Cursors.Default() Application.DoEvents() Dim mouseCur As Cursor Me.Cursor = Windows.Forms.Cursors.WaitCursor bkps.SQLBackup(oSQLServer) ProgressBar1.Value = 100 Application.DoEvents() bkps = Nothing Me.Cursor = Windows.Forms.Cursors.Default() MsgBox("数据库备份完成", MsgBoxStyle.Information, "系统消息") End Sub '显示进度 Private Sub bkps_PercentComplete(ByVal Message As String, ByVal Percent As Integer) Handles bkps.PercentComplete ProgressBar1.Value = ProgressBar1.Maximum * (Percent / 100) End Sub 把DTS包保存成vb模块在程序里调用就行了 用opendatasource()函数做的导出实质上都是通过SQL的DTS服务做的如:insert into opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=e:\95Sales.xls;User ID=Admin;Password=; Persist Security Info=False;Extended properties=Excel 5.0')...[sheet1$] select * from tabel1 faysky2() ,你那段代码还有很多问题,请给我一段完整的代码,OK? 推薦SQLDMO,如果SQL SERVER完全安裝的話,在安裝目錄下有各種語言的示例代碼。 关于两段程序代码对同一数据库访问的问题。急! 谁能提供象QQ折叠菜单的源码 VB6能否调用.Net程序集? 急问:API函数Shell_NotifyIcon的使用问题!!!!! 高分求类似spliter的实现方法(在线)分多的受不了 如果只知道文件扩展名,如何找到与之关联的(大小)图标呢? 我该怎么办啊? 请高手帮帮我有关打包的问题 请问用vb能否实现在word中找到每个“标题” 推荐一本关于VB.net和Design Patterns的书,下载地址 VB 怎样判断一个数 ( a / 2 ) 带不带小数点阿 马上给分了 求助:如何判断EXE程序已经打开
'?添加进度条ProgressBar1控件
'?引用Microsoft SQLDMO Object Library '声明
Public WithEvents bkps As SQLDMO.Backup '数据库备份操作
Private Sub btnBackUp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBackUp.Click
Dim oSQLServer As New SQLDMO.SQLServer()
oSQLServer.LoginSecure = False
oSQLServer.Connect("(local)", "sa", "sa") '连接服务器
Me.Cursor = Windows.Forms.Cursors.WaitCursor
bkps = CreateObject("SQLDMO.Backup")
bkps.Database = "Northwind" '指定需备份的数据库
bkps.Action = 0
bkps.Files = "f:\Northwind.bak" '指定备份文件
bkps.Initialize = True
ProgressBar1.Value = 0
ProgressBar1.Maximum = 100
Me.Cursor = Windows.Forms.Cursors.Default()
Application.DoEvents()
Dim mouseCur As Cursor
Me.Cursor = Windows.Forms.Cursors.WaitCursor
bkps.SQLBackup(oSQLServer)
ProgressBar1.Value = 100
Application.DoEvents()
bkps = Nothing
Me.Cursor = Windows.Forms.Cursors.Default()
MsgBox("数据库备份完成", MsgBoxStyle.Information, "系统消息")
End Sub '显示进度
Private Sub bkps_PercentComplete(ByVal Message As String, ByVal Percent As Integer) Handles bkps.PercentComplete
ProgressBar1.Value = ProgressBar1.Maximum * (Percent / 100)
End Sub
在程序里调用就行了
insert into opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source=e:\95Sales.xls;User ID=Admin;Password=; Persist Security Info=False;
Extended properties=Excel 5.0')...[sheet1$] select * from tabel1
如果SQL SERVER完全安裝的話,
在安裝目錄下有各種語言的示例代碼。