How to differentiate Records

Question

0.00/5 (No votes)

See more:

, +

I have two files (1) Access (2) Excel in both there are many records available. There are more than 50000 and I want to find out how many new records are not available in Access which are in Excel. :confused: both files structure are not the same. There is just one identical column in both files.

~~It's urgent plz.~~

Thanks in advance! :)

Posted 13-Jan-11 2:45am

MaulikDusara

Updated 13-Jan-11 2:53am

Manfred Rudolf Bihy

v2

Add a Solution

Comments

Manfred Rudolf Bihy 13-Jan-11 8:56am

If it were really urgent you would have shown the structure of both files, i.e. all the column names for the table in your Access DB and all the column names of your Excel. How are we supposed to help you if you don't leave any usefull information whatsoever. "It's urgent plz" can definitely not be considered usefull information. Thank you!

OriginalGriff 13-Jan-11 9:07am

How do you expect anyone to be able to help when you specifically tell them that the two are different, but do not tell us what they have in common?
It is like writing a shopping list for "supper" and being surprised when I come back with steak and potatoes instead of salmon and rice.

Manfred Rudolf Bihy 13-Jan-11 9:51am

@OriginalGriff: Steaks and potatoes for supper will be fine with me. :)

fjdiewornncalwe 13-Jan-11 10:20am

Griff, I like both. So when should I be there. (I'll bring the wife and wine)

Prashant Srivastava LKO 14-Dec-11 15:06pm

:)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Simon_Whale · Accepted Answer · 2011-01-13T03:30:00

Solution 1

import the excel data and run an outer join query

Access Outer join query[^]

Posted 13-Jan-11 3:30am

Simon_Whale