Get Column Names

how do i get the Column Names of a Table in Access.
i know how to do in SQL Server 2000, so wanted to if it is possible in Access as Well

Use ADO.

Open the table in a recordset, and from there you could do this:

VB Code:

Dim i As Integer
For i = 0 to oRecordset.Fields.Count - 1
  MsgBox "Column " & (i + 1) & " : " & oRecordset.Fields(i).Name
Next