How to get Column names from empty table (Desc in Oracle)

[desi5pure]

How can I get column names from a table that doesn't have any data or has data (just like DESC command in Oravcle)?

 

[GingerR]

Here's code that goes thru all of your tables and lists their fields in a table called TestTables. you should be able to tweak it for your needs.

Make a table called TestTables.
Two fields (both text):

TestTableName
TestFieldName


Create a code module and paste this into it:

Function TableList()
    CurrentDb.Execute ("Delete * from TestTables")
    Dim rs As DAO.Recordset
    Set rs = CurrentDb.OpenRecordset("Select * from TestTables")
    
    
    Dim tbf As DAO.TableDef
    Dim fld As Field
        For Each tbf In CurrentDb.TableDefs
           For Each fld In tbf.Fields
                    rs.AddNew
                    rs!TestTableName = tbf.Name
                    rs!TestFieldname = fld.Name
                    rs.Update
            Next fld
        Next tbf
    Set rs = Nothing
End Function

Run the function, look in your table.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[PHV]

You may also consider an ADOX.Catalog object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[desi5pure]

Thanks both.