Query/Module Question

[Guest]

I have a spreadsheet that I would like to import into my database, the thing
is that I do no want to import duplicates. The spreadsheet has e.g., infor
such as customer name, loan number comments and alot of other infor. There
is no unique identifier in the spreadsheet. the loan number could appear
more than once with one or more column differences.

So how will import the data into my database and not duplicate rows...

 

[Jeff Boyce]

It sounds like you are saying there is no way to tell if there are
duplicates (no unique identifier, possibility of multiple records for each
loan number, etc.).

How do YOU tell that a spreadsheet row is a duplicate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

The information in the spreadsheet is coming from a mainfrom program.
The spreadsheet will contain infor such as (this is just an illustration as
there are about 1o columns)

loan Number: 123456
Borrower: John
Action Code: XYZ
Action Reason: EM12-123

loan Number: 123456
Borrower: John
Action Code: XYZ
Action Reason: EF12-100

loan Number: 789654
Borrower: Mark
Action Code: XYZ
Action Reason: EF12-127

 

[Jeff Boyce]

Thank you for an example of the data you receive. My question still stands.
What criteria are YOU using to determine "uniqueness" of a record? You need
to be able to explain that before you can hope to tell Access how to do
that...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,
A loan number needs to be unique, but that would contradict the example I
provided. When the data is imported, access generates a PK.

 

[Jeff Boyce]

We don't seem to be talking about the same thing.

Step back from the Access/Excel situation for a moment...

Imagine you have a stack of papers, each sheet containing a collection of
data (?a transaction).

You hand the stack to someone else and say "If you already have a copy of
one of these sheets in YOUR stack, you can throw MY copy away; otherwise,
add MY copy to YOUR stack."

The person you hand the stack to would have to look at YOUR copy and somehow
figure out if s/he already had a copy of the same sheet. How would s/he
decide? What data on YOUR sheet would have to match what data on HIS/HER
sheet for the person to call them a copy?

Regards

Jeff Boyce
Microsoft Office/Access MVP