Column Names from a Table in MS Access

  • Thread starter Thread starter Matthias Kwiedor
  • Start date Start date
M

Matthias Kwiedor

Hi!

I know this is a realy simple question (maybe) :)

But how can i get with an SQL Query all column names out from a table?

Example:

table-name: test
columns: - test_1
- test_2
- test_3

and now i want with "select from test" getting the headers back (test_1,
test_2, test_3)

How can i do this?


Thanks



Matthias
 
You would be better off writing some DAO code to retrieve the info you
require.

Check out the Table object of DAO. it will have a Fields collection, you
can loop thru this collection.
Look in the help for code examples.
 
Back
Top