Need a list of column names in a access table

[kayek]

To get a list of column names from SQL Server Table "tblMain1" the below SQL code works.

SELECT sysobjects.name,
syscolumns.name AS ColumnName
FROM syscolumns
INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE sysobjects.name = N'tblMain1'

How can I do the same thing in Access?

 

[kjv1611]

Is this supposed to be pulling from a specific table? Just wondering, b/c "syscolumns" doesn't sound like a common table name..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[flyover789]

in access you have to do this with VBA.
take look at thread

http://www.tek-tips.com/viewthread.cfm?SQID=845526&SPID=705&newpid=705&page=1

HTH,
fly

Martin Serra Jr.

http://www.mserrasystems.com