how to get the name of all the columns in an Access table?

[Guest]

Hi,

Does anyone know how to get the name of all the columns in an Access table? Is there a SQL statement like "SELECT COLUMN_NAME FROM TABLE_NAME" to achieve that?

Thanks in advance!

 

[Allen Browne]

You can retrieve the Name of each Field in the TableDef (DAO). Example:
http://allenbrowne.com/func-06.html

If you prefer to use ADOX, you can loop through the Columns of the Table in
the Catalog.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Does anyone know how to get the name of all the columns in an Access

table? Is there a SQL statement like "SELECT COLUMN_NAME FROM TABLE_NAME"
to achieve that?

 

[Ken Snell]

Use VBA code (example below prints the name in Immediate Window; you can
write the names into an array if you wish):

Dim intField As Integer
Dim dbs As DAO.Database
Dim rst As DAO.Recordset

Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("Table_Name", dbOpenDynaset, dbReadOnly)

For intField = 0 To rst.Fields.Count - 1
Debug.Print rst.Fields(intField).Name
Next intField

rst.Close
Set rst = Nothing
dbs.Close
Set dbs = Nothing

--
Ken Snell
<MS ACCESS MVP>

Hi,

Does anyone know how to get the name of all the columns in an Access

table? Is there a SQL statement like "SELECT COLUMN_NAME FROM TABLE_NAME"
to achieve that?