linked Sql server table properties

[supmktg]

I need to update data in a bunch of tables of a sql server database. The database has 300 tables which I have linked via odbc. I'm hoping there is a simple way, using vba, to loop through my linked sql server tables and determine which of them are views as opposed to tables.

Any help would be greatly appreciated!

Sup

 

[supmktg]

I discovered that the linked sql server table "sys_objects" includes a field for table type. I no longer need to write code to find that info.

Thanks,
Sup