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

centralmike
centralmike used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

How are you suppose outthe column names in a table in vba code ?

Author

Commented:
How are you suppose to put column names in a table in vba code?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial