select * from bbb as select * from aaa
解决方案 »
- 如何利用DOS下的FTP命令批量下载昨天的文件
- 急!在一段程序中要通过find方法查找一条记录,其中关键字是一个字符串量,我在程序中这样写:
- 请教这个API函数怎么写。。。谢谢
- 请高手指点如何在ListView中用checkbox显示和修改的问题!!!问题解决分不够可以另加
- 如何把 XSL -> MDB ?
- 请问怎样按拼音索引查找汉字
- 哪里有可以类似listview,但可以在程序中直接修改选项的控件,向EXCEL
- 为什么我用不起shockwave flash控件????
- 又是“必须使用可更新的查询”错误,我这样写有错吗?ACCESS
- 关于数据库备份和还原的问题
- 是高手吗!进来试试!!有100分的礼物等你拿呢!!不过可要答对呀!!!!
- 如何用代码实现控件的选择效果
Dim conn2 As New ADODB.Connection
Dim str As String
str="Provider=Microsoft.Jet.4.0;Database=" & $PATH$ & "\AAA.mdb;PWS=;"
conn1.open str
str="Provider=Microsoft.Jet.4.0;Database=" & $PATH$ & "\BBB.mdb;PWS=;"
Dim rs As New ADODB.Recortset
str="select * from table"
rs.Open str,conn,3,4
Dim i As Integer
For i = 1 To rs.RecordCount
str="insert into table(" & $FIELD1$ & …… & $FIELDn$ & ") " & _
"values('" & rs("field1") & "','" & …… & rs("field1") & _
"')"
conn2.Execute(str)
rs.MoveNext
Next i比较苯,不过肯定行。
Private Sub ExportExcelSheetToAccess(sSheetName As String, sExcelPath As String, sAccessTable As String, sAccessDBPath As String)
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(sExcelPath, True, False, "Excel 5.0")
Call db.Execute("Select * into [;database=" & sAccessDBPath & "]." & sAccessTable & " FROM [" & sSheetName & "$]")
MsgBox "Table exported successfully.", vbInformation, "Yams"
End Sub
FROM [" & sSheetName & "$]")中的sheetname用什么代替?