Comparing two tables for missing columns

[Guest]

Hello,
I am more accustomed to Oracle.... am still thinking in terms of Oracle...
Please help me with this issue.
I am trying to compare two tables A and B...
I want only the column names of the missing column on the other database...
in other words I want
A intersection B for column names &
B intersection A for column names...
I am not interested in the data that is present in those columns.
Then I need to add / alter the tables A and B to make them similar. Eg:
A B
-------------------------------
Name Name
Class Section
County County
State District
Country Country

I need
A intersection B = Section, District
B intersection A = Class, State
and then make them
A B
-------------------------------
Name Name
Class Class
Section Section
County County
District District
State State
Country Country

Please help.
Thanks
Shree

 

[Guest]

Unfortunately Access doesn't have any views like DBA_TAB_COLS where this
would be easy. You'll need to do some coding. Here's a place that might help:

http://www.freevbcode.com/ShowCode.asp?ID=184