想用dao来创建一个access数据库,需要先从sql数据库中读取记录,然后创建access数据库,把sql一个数据库中的一个表的记录转换到access中
解决方案 »
- 谁能帮我把这个标准 DLL 连接到 VB 中?
- 清华大学出版社的《VB案例解析》不错
- 如何改变工具栏的字体啊?
- vb中用pic控件load图片(链接,非嵌入式),打包时,如何将图片打包成。。。。
- 刚才字符串存入数组贴给的分数太少,另外再发一次,不够分可另外再加
- datareport 如何在程序中设置横打?( 报表栏目没人理我,这里的人气好!)
- 各位大虾, 请问在用VB做播放器时,怎么实现全屏播放呀
- 【求助】代码出现错误438,求解!
- 如何在vb中做超级链接,当点中之后,自动弹出IE?急
- “MSDN集合不存在,请重新安装MSDN“,MSDN在哪里有? 是个什么东东Y
- sql语句问题?
- 请问怎么改变toolbar和菜单的景色不要都是灰色。能不能自定义?
Dim backm As Database
SQL = ""
On Error Resume Next
jdt.Max = 180
jdt = 1
Kill App.Path + "\backup\" + Trim(Text2)
FileCopy App.Path + "\backup\backup.mdb", App.Path + "\backup\" + Trim(Text2)
jdt = 10
Set backm = Workspaces(0).OpenDatabase("czic", dbDriverNoPrompt, False, "DSN=czic;UID=sa;PWD=*********;DATABASE=icdb;")
''dbsql.Execute "select * into [;database=C:\quenry\shzc\temp.mdb].sghtmx from buycondetail where 1=2 "
''dbsql.Close
jdt = 20
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].sys_log from sys_log where 1=1"
backm.Execute SQL
jdt = 30
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].addedit from addedit where 1=1"
backm.Execute SQL
jdt = 40
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].badic from badic where 1=1"
backm.Execute SQL
jdt = 50
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].company from company where 1=1"
backm.Execute SQL
jdt = 60
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].detail from detail where 1=1"
backm.Execute SQL
jdt = 70SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].dw from dw where 1=1"
backm.Execute SQL
jdt = 80
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].iccard from iccard where 1=1"
backm.Execute SQL
jdt = 90
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].icpsw from icpsw where 1=1"
backm.Execute SQL
jdt = 100
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].jfname from jfname where 1=1"
backm.Execute SQL
jdt = 110
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].jftype from jftype where 1=1"
backm.Execute SQL
jdt = 120
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].kjkm from kjkm where 1=1"
backm.Execute SQL
jdt = 130
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].pass from pass where 1=1"
backm.Execute SQL
jdt = 140
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].total from total where 1=1"
backm.Execute SQL
jdt = 150
SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].users from users where 1=1"
backm.Execute SQLjdt = 160SQL = "select * into [;database=" + App.Path + "\backup\" + Trim(Text2) + "].jfkmdm from jfkmdm where 1=1"
backm.Execute SQLMsgBox "数据库整理完成!!请插入一张格式化好的软盘!!"
SQL = App.Path + "\winzip\winzip32.exe " + App.Path + "\backup\" + Trim(Text2)
Shell SQL
引用DAO3.6
Dim Wrk As Workspace
Set Wrk = DBEngine.Workspaces(0)
Set Dbs = OpenDatabase(DatabasePath, False, False)
Set dbs = DBEngine.Workspaces(0).OpenDatabase(DatabasePath, False, False)
Set tdfNew = dbs.CreateTableDef(TableName & "Outputtemp")
tdfNew.Fields.Append tdfNew.CreateField(Col1, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col2, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col3, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col4, dbText)
dbs.TableDefs.Append tdfNew
我这个方法是VB里的,不知你需要不
Dim Wrk As Workspace
Set Wrk = DBEngine.Workspaces(0)
Set Dbs = Wrk.CreateDatabase(App.Path & "\" & DatabaseName & TableName & "Outputtemp.mdb", dbLangChineseSimplified)
Set tdfNew = Dbs.CreateTableDef(TableName)
r.Fields(i).Type 就是类型
说实话 用这个办法速度很慢的, 不适合大两数据转换
Function Explistv(ll As ListView, rr As ADODB.Recordset, bt As Boolean) As String
'将ADO记录集直接输出到LISTVIEW
Dim r As New ADODB.Recordset
Dim i As Integer
Dim ITMX As ListItem
Set r = rr
ll.ListItems.Clear
Explistv = ""
'添加标题
If bt = True Then
ll.ColumnHeaders.Clear
For i = 0 To r.Fields.Count - 1
Explistv = Explistv & Trim("," & r.Fields(i).Name)
ll.ColumnHeaders.Add , , Trim(" " & r.Fields(i).Name & "__" & r.Fields(i).Type)
Next
End If
'添加内容
Do While Not r.EOF
Set ITMX = ll.ListItems.Add(, , Trim(" " & r.Fields(0).Value & " "))
For i = 1 To r.Fields.Count - 1
'字符型
ITMX.SubItems(i) = Trim(" " & r.Fields(i).Value & " ")
Next
r.MoveNext
Loop
r.Close
End Function
qq:31735258
完了还有分Private Sub Export2Mdb(pRSet As ADODB.Recordset, sFileName As String)
On Error GoTo ErrorHandler' pRSet.MoveFirst
' Dim pWrk As DAO.Workspace
' Set pWrk = DAO.DBEngine.Workspaces(0)
' Dim pDb As DAO.Database
' Set pDb = pWrk.CreateDatabase(sFileName, dbLangGeneral, dbEncrypt)
' Dim pTabDef As DAO.TableDef
' Set pTabDef = pDb.CreateTableDef("ExportMDB")
' Dim pField As DAO.Field
' Dim I As Long
' For I = 0 To pRSet.Fields.Count
' Select Case pRSet.Fields(I).Type
'
Exit Sub
ErrorHandler:
HandleError False, "Export2Mdb " & c_sModuleFileName & " " & GetErrorLineNumberString(Erl), Err.Number, Err.Source, Err.Description, 4
End Sub