I have an Access 97 database, and I need to get the column names from a specific table and use these as headings in a listview control. Can this be done through the data control in VB or do I need to use some kind of SQL statement?

Even just an example on how to get metadata from an access database would be great.

Thanks