Duplicates

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am importing a text file into a new table [Bus] daily.
The text file has duplicates. I want to import only one of
the two duplicate records. How can I do that in Access?
And is it possible to tye that to the import spec?

Dennis
 
The bus file comes from another source that I cannot
control. On this file there are duplicates. I import this
file into a new table daily with no primary key to allow
the duplicates or the import errors out. I want to append
another table (IRecords) with some of the records in the
bus table and maybe some of the duplicate records are
records that need to be appended to the table IRecords.
IRecords has a unique index but as stated, not bus. I
could make a table called bus and create a unique index
but will that only import one of the records? Or will the
import error out?

Dennis
-----Original Message-----
Can you create a unique index on the table so that duplicates are
impossible?

--
Duane Hookom
MS Access MVP


I am importing a text file into a new table [Bus] daily.
The text file has duplicates. I want to import only one of
the two duplicate records. How can I do that in Access?
And is it possible to tye that to the import spec?

Dennis
Click to expand...


.
Click to expand...
 
I can't tell if there is a reason for importing duplicate records or not. I
generally import into a "holding" table. You can then create a totals query
based on the Holding table to append to another table.

--
Duane Hookom
MS Access MVP


Dennis said:
The bus file comes from another source that I cannot
control. On this file there are duplicates. I import this
file into a new table daily with no primary key to allow
the duplicates or the import errors out. I want to append
another table (IRecords) with some of the records in the
bus table and maybe some of the duplicate records are
records that need to be appended to the table IRecords.
IRecords has a unique index but as stated, not bus. I
could make a table called bus and create a unique index
but will that only import one of the records? Or will the
import error out?

Dennis
-----Original Message-----
Can you create a unique index on the table so that duplicates are
impossible?

--
Duane Hookom
MS Access MVP


I am importing a text file into a new table [Bus] daily.
The text file has duplicates. I want to import only one of
the two duplicate records. How can I do that in Access?
And is it possible to tye that to the import spec?

Dennis
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top