Dim Cntemp As New ADODB.Connection
Dim Retemp As New ADODB.Recordset
Dim Re As New ADODB.Recordset
Dim FileWorker
Dim i As Long
Dim lngRecount As Long
Set FileWorker = CreateObject("Scripting.FileSystemObject")
FileWorker.copyfile "\\ksntser\ksnt_01\kum\worker.dbf", "c:\worker.dbf"
Cntemp.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=c:\"
Retemp.Open "SELECT NAME,BR_CODE,DEPT From worker WHERE (((worker.DEPT) Like '%车衣%' Or (worker.DEPT) Like '%质检%') AND ((worker.RESON) Is Null))", Cntemp, adOpenStatic, adLockReadOnly, adCmdText
cnMain.Execute "delete from workerinfo" ‘cnmain是我的SQL服务器的连接变量
Re.Open "workerinfo", cnMain, adOpenStatic, adLockOptimistic, adCmdTable
Retemp.MoveLast
lngRecount = Retemp.RecordCount
MsgBox lngRecount
Retemp.MoveFirst
For i = 1 To lngRecount
Re.AddNew
Re("name") = Trim(Retemp("name"))
Re("br_code") = Trim(Retemp("br_code"))
Re("dept") = Trim(Retemp("dept"))
Re.Update
Retemp.MoveNext
Next i
Dim Retemp As New ADODB.Recordset
Dim Re As New ADODB.Recordset
Dim FileWorker
Dim i As Long
Dim lngRecount As Long
Set FileWorker = CreateObject("Scripting.FileSystemObject")
FileWorker.copyfile "\\ksntser\ksnt_01\kum\worker.dbf", "c:\worker.dbf"
Cntemp.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=c:\"
Retemp.Open "SELECT NAME,BR_CODE,DEPT From worker WHERE (((worker.DEPT) Like '%车衣%' Or (worker.DEPT) Like '%质检%') AND ((worker.RESON) Is Null))", Cntemp, adOpenStatic, adLockReadOnly, adCmdText
cnMain.Execute "delete from workerinfo" ‘cnmain是我的SQL服务器的连接变量
Re.Open "workerinfo", cnMain, adOpenStatic, adLockOptimistic, adCmdTable
Retemp.MoveLast
lngRecount = Retemp.RecordCount
MsgBox lngRecount
Retemp.MoveFirst
For i = 1 To lngRecount
Re.AddNew
Re("name") = Trim(Retemp("name"))
Re("br_code") = Trim(Retemp("br_code"))
Re("dept") = Trim(Retemp("dept"))
Re.Update
Retemp.MoveNext
Next i
解决方案 »
- 如何将任意长度(比如20位)的十进制数转换为十六进制?
- 请指教:怎么把窗体1中变量的值,赋给窗体2中的变量!
- 请教好心人,关于IHTMLDocument2对象的支持问题
- 问个TEECHART的问题,高手进来.
- 关于dategrid怎样与数据库相连?急需............
- 寻找可以自定义查询的模块
- Winsock控件无法使用&RichTexBox的问题
- 如何用vb显示动画
- 谁碰到vb在写代码时tab键不好用的问题?
- hnlzh(吸海垂虹),songyangk(小草),我的OICQ:7774710,在上面说好吧???在这上面我只能说三次话!!!
- 大侠们!帮帮我吧!求你们了!
- 微软的BUG还是我电脑的BUG还是我的BUG?
Set FileWorker = CreateObject("Scripting.FileSystemObject")
FileWorker.copyfile "\\ksntser\ksnt_01\kum\worker.dbf", "c:\worker.dbf"
试试下面语句
Dim xiaoshou1 As New ADODB.Recordset '定义ADO
DIM XIAOSHOU2 AS NEW ADODB.RECORDSET
g_dbname="d:\cmis\sale.mdb"
strconnect = "User ID=Admin;Password=;Data Source=" & g_dbname & _
";Provider=Microsoft.Jet.OLEDB.3.51"'ado方式打开数据库
sql$ = "SELECT * from 临时销售表 "
xiaoshou1.Open sql$, strconnect, adOpenKeyset, adLockOptimistic, adCmdText
sql2$="SELECT * from 销售表"
xiaoshou1.Open sql$, strconnect, adOpenKeyset, adLockOptimistic, adCmdText
Do Until xiaoshou1.eof
xiaoshou2.AddNew
xiaoshou2!发票ID = xiaoshou1!发票ID
xiaoshou1.MoveNext
Loop
xiaoshou1.close
xiaoshou2.close
strconnect = "User ID=Admin;Password=;Data Source=" & g_dbname & _
";Provider=Microsoft.Jet.OLEDB.3.51"
中的Provider的值改成Microsoft Visual Foxpro ,再把相应的名称换成.dbf就行了呀