说的明白一点
我想得到,数据库的所有表名。
access,excel
我想得到,数据库的所有表名。
access,excel
解决方案 »
- GDI+绘制文字的问题
- 求高手,用VB往SQL数据里里面写JPG图片 还有读出图片的代码出现的一些问题。
- 各位大哥大姐,有熟悉visual Foxpro 的吗?有问题急需解决!!
- format的问题2
- 急救!类型转换问题
- 现在好像没有企业需要VB了,那些VB程序员应该都是以前上了岸的,没上岸或者没那种机遇的人如何定目标?
- 如何在输入的字符串中找出特定的字母,如d,g,i,m,然后显示出来?
- 怎样控制系统音量?
- 突然想到一个问题,关于变量命名,不知道有没有想到过...
- 还有三个小时就再也不能上网了。所有分都给大家!
- 我用ADO操作ACCESS数据库时,碰到一个问题,大家来看看
- 初学者问连接数据库的问题!
ACCESS里可以用系统表mssysobjects,EXCEL有待研究。
请先在工程中引用 Microsoft SQLDMO Object Library
代码如下:Private Sub Form_Load()
'-------------------------------------------------------------
'获取服务器上所有数据库名并加载到组合框的方法
On Error GoTo ON_ERROR
Dim rsDB As New ADODB.Recordset
Dim i As Integer
cobDatabase.Clear
i = 1
Set rsDB = conServer.OpenSchema(adSchemaCatalogs)
While Not rsDB.EOF
cobDatabase.AddItem rsDB!CATALOG_NAME
rsDB.MoveNext
i = i + 1
Wend
cobDatabase.ListIndex = 1
rsDB.Close
Set rsDB = Nothing
'-------------------------------------------------------------
'附送获得所有服务器名称的方法
Dim dom As SQLDMO.NameList
Dim Server As New SQLDMO.Application
Set dom = Server.ListAvailableSQLServers
Dim i As Long
For i = 1 To dom.Count
cobSQLserverName.AddItem dom(i)
Next i
' cobSQLserverName.ListIndex = cobSQLserverName.ListCount - 1
Set Server = Nothing
cobDatabase.Text = "SoupEvenFlowManage"
GetServerName = True
Exit Function
ON_ERROR:
MsgBox "错误代码:" & Err.Number & vbCrLf & _
"错误描述:" & Err.Description, _
vbInformation + vbOKOnly, "系统提示"
Err.ClearEnd Function'注意自行设置连接字符串
SoupEvenFlowManage '为数据库名称
Dim adoCN As New ADODB.Connection 'Access的
Dim strCnn As New ADODB.Recordset
str1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb" & ";Persist Security Info=False"
adoCN.Open str1
Set rstSchema = adoCN.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
out = out & "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
rstSchema.MoveNext
Loop
rstSchema.Close
adoCN.Close
Debug.Print outEnd SubPrivate Sub Command2_Click()
Dim adoCN As New ADODB.Connection 'Excel的
Dim strCnn As New ADODB.Recordset
str1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= " & App.Path & "\Book1.xls;" & "Extended Properties=""Excel 8.0;HDR=Yes;"";"
adoCN.Open str1
Set rstSchema = adoCN.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
out = out & "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
rstSchema.MoveNext
Loop
rstSchema.Close
adoCN.Close
Debug.Print outEnd Sub
Dim rs As New ADODB.Recordset
conn.ConnectionString = "driver={microsoft excel driver (*.xls)};dbq=" & FileString
conn.Open
Set rstSchema = conn.OpenSchema(adSchemaTables)
Dim TableName()
Dim TableID
TableID = 0
Do Until rstSchema.EOF
ReDim Preserve TableName(TableID)
TableName(TableID) = rstSchema!TABLE_NAME
TableID = TableID + 1
rstSchema.MoveNext
Loop
rstSchema.Close
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;
原来怎么没注意这个OpenSchema?