SQL statement for listing field headings in a table? (Access 97)

[TimeTraveler]

I posted this question in ASNI SQL and was instructed to post here instead.

What is the SQL statement to list the column names of a table?

I've poured through SQL Unleashed, and Microsoft KB and Google, as well Tek-Tips FAQ sections and posts. The only thing I saw was page describing some VB Module to include in the database, but really no instructions on its use, despite a 'usage:' line in its comments.

http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=1

I refuse to believe that Access 97 cannot perform this simple type of query that's provided for in a 30-year old non-SQL C-Tree database.

Visit

http://www.museworksentertainment.com/gear.html

 

[DotNetGnat]

this is what we use in SQL Server...

SELECT Column_Name FROM Information_Schema.Columns
WHERE Table_Name = 'yourtablename'

not sure of how its done in MS Access...

-DNG

 

[DotNetGnat]

take a look at this link...might help you out...

http://www.experts-exchange.com/Databases/MS_Access/Q_20786171.html

-DNG