Exclude Duplicate records from Import

[loscherland]

I'm running a database query in excel to import data from an acces
database to exel

Some of the records are duplicated 3, 4 & 5 times in the database. I
there any way of excluding these duplicate records when importing? i.e
just importing the first of every duplicate record?

Example of Row fields in data base are as follows:

BRANCH CODE; PHONE NO; DATE; NAME; REQUEST DAT
A224 555-424 01/01/04 Jim 10/01/04
A224 555-424 01/01/04 Jim 17/01/04
A233 444-333 03/01/04 Bob 12/01/04

2nd record in example above is a duplicate - Everything is same excep
Request date - This is the only field that will differ from the firs
record - All other data is the same.

Is there any way of excluding these records? - i.e. IF Phone No is sam
as phone no previously requested, then do no import

 

[Frank Kabel]

Hi
I would set-up a specific query in MS Access to filter out duplicates.
One way could be (not tested though)

- Group the query for the first 4 columns.
- use the MIN grouping function on the 4th column

This should filter out the duplicates in your example. Now use this MS
Access query for importing your data to Excel

 

[onedaywhen]

Take a look at the SQL keyword 'DISTINCT'. If you don't have MS
Access, here's a link to the Jet 3 help files on MSDN (note Jet 4.0
has a revised syntax for DISTINCTROW but I couldn't find a more
up-to-date online help file ):

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A319.asp

--