使用oledb连接访问Microsoft Access以检索架构信息不显示链接的Excel表 [英] Access Microsoft Access with oledb connection to retrieve schema info does not show linked excel tables

问题描述

我正在尝试打开与MS Access的连接以检索架构信息(表，查询).
当Access DB具有链接到Excel工作表的表时，该表不作为可用表返回吗? 这是一个错误吗?

I am trying to open a connection to MS Access to retrieve schema info (tables,queries).
When the Access DB has a linked table to an excel sheet, the table is not returned as available table????
Is this a bug?

Dim Dbf As DbProviderFactory
Dim Con As DbConnection

Dbf = DbProviderFactories.GetFactory("System.Data.OleDb")
Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb"

Dim Dtt = Connection.GetSchema("Tables")

For i As Integer = 0 To Dtt.Rows.Count - 1
  'walk through the items
Next 

推荐答案

否.该模式仅显示对象是数据库结构的一部分，而不是数据库使用的资源.

No.  The schema only show that objects that is part of the database structure and not the resources that the database uses.

这篇关于使用oledb连接访问Microsoft Access以检索架构信息不显示链接的Excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！