I need to compare one access table to another to show missing columns.

I need to know if it possible to loop through a recordset(tblViewNames) comparing one table to another.  I need to be able to output column that don't exist in the BI View tables from the CR tables . I have a sample query created in Teradata  where it shows BI columns missing from the CR Tables comparison.  Then I need to output this missing columns to a table(tblFinalOutput).
Edge_Ticket.accdb
td_example.xlsx
centralmikeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bfuchsCommented:
this is the code that loops thru all fields of a table, use this as a start and modify accordingly...
	Dim fld As DAO.Field
	For Each fld in tdf.fields
		If(fld.Type = dbDate) Then
			SQL = SQL & "Employeestbl.[" & fld.name & "],"
		End If
	Next

Open in new window

0
Luke ChungPresidentCommented:
If you're open to a commercial solution, our Total Access Detective program compares any two objects in one database, or identically named objects in two databases for differences. This includes table structures, indexes, data, queries, forms, reports, macros and modules.

http://fmsinc.com/MicrosoftAccess/DatabaseCompare.html
0
centralmikeAuthor Commented:
How are you suppose outthe column names in a table in vba code ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
centralmikeAuthor Commented:
How are you suppose to put column names in a table in vba code?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.