Turns out I've answered my own question (DOH!!) turns out I can use the
get oledbschema table method.
 
Had to buy yet another wrox book to find it out though (my fifth!!)
 
Ah well I guess I'll have to buy myself a beer for sorting it out