CODBC Question

barondense

Hello and good day to you all. I'm new here, so I don't know you, but it seems that this place is full of good people so I'm happy to have found you.

I'm trying to code a procedure that dumps certain data from the Native Attain database to an access database. The database I'm working on is the danish version so table and field names are in danish. The version is 3.70.

When I look at the data through linked tables in access, some of them show up twice (activity, personel etc..) When looking through the SQL server Import/export util, it looks like one is a table and one is a view. but I can't seperate the two using code. When use the ADO openschema and look at tables, they each show up twice with TABLE as the type.

I could make it work by hardcoding some stuff, but I would like to make generic code. So if anybody has some insight into how to catch what is a view and what is a table in the database through CODBC, I'd be very happy

Thank You

Bo