怎样获取access数据表的列名

[mocherson]

怎样获取access数据表的所有列名，比如我创建的表tb_data中有三列name，age，sex。获取这些名称的SQL语言怎么写？谢谢？

[wwwwb]

没有这样的SQL语句，用ADO、ADOX来取得

[wwwwb]

OR
DAO

ADOX:
Dim ff As New ADOX.Catalog

ff.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\zz\db3.mdb;Persist Security Info=False"

For Each ff21 In ff.Tables
If ff21.Type = "TABLE" Then
For Each dr1 In ff21.Columns
MsgBox dr1.Name & " 123 " & dr1.DefinedSize & " 456 " & dr1.Type
NEXT

END IF
NEXT

[wwwwb]

OR
DAO

ADOX:
Dim ff As New ADOX.Catalog

ff.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\zz\db3.mdb;Persist Security Info=False"

For Each ff21 In ff.Tables
If ff21.Type = "TABLE" Then
For Each dr1 In ff21.Columns
MsgBox dr1.Name & " 123 " & dr1.DefinedSize & " 456 " & dr1.Type
NEXT

END IF
NEXT

[ACMAIN_CHM]

获取ACCESS表结构
http://blog.csdn.net/ACMAIN_CHM/archive/2008/12/24/3598577.aspx

[netcellsoft]

还有这么多人用ACCESS呀.

[有心人问道]

请问netcellsoft兄用的什么？介绍一下啊！我用的是c#，想学习一下。

[wanghonghua123]

正在学习中。。。