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.