Get table column names from Access...

[lidds]

I am really struggling with getting the column names from a MS Access table, I have been googling for some time now and can not seem to find an example that works.

 

Any help would be really apreshiated

 

Thanks in advance

 

Simon

[Nate Bross]

I forget the Access Keywords, but something like this should work for you.

 

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = <table_name>

I have not tested this; it may be SQLS only.