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

 

[jmcilhinney]

Create an OleDbConnection with the appropriate connection string, open it and call GetSchema. Specify "TABLES" as the collection name to get info on tables and specify "COLUMNS" as the collection name to get info on columns. Specify no collection name to get a list of collections you can query.