[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

I need to compare 2 access 2010 tables. One is the original the other an updated version. I need to track the changes. There is no unique ID so JOINs are difficult. VBA code may be required.

Posted on 2014-08-20
2
Medium Priority
?
569 Views
Last Modified: 2014-08-26
I need to compare 2 access 2010 tables. One is the original the other an updated version. I need to track the changes between the two and populate a third table with the differences. There  is no unique ID so JOINs are difficult. VBA code may be required but I don't do much coding. There are only 15 columns but thousands of rows. Any assistance with SQL, JOINS or VBA to resolve this would be appreciated.
0
Comment
Question by:Khadir Paden
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 1500 total points
ID: 40274513
I would used ODBC connection from SQL to import the data or just link the tables so you can run inside SQL a command like below that will give the differences between the two identical structure tables:


SELECT * FROM AccessTable1
EXCEPT
SELECT * FROM AccessTable2

UNION

SELECT * FROM AccessTable2
EXCEPT
SELECT * FROM AccessTable1
0
 

Author Closing Comment

by:Khadir Paden
ID: 40287070
That helped
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question