Column Names from a Table in MS Access

[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

 

[Sean]

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.