appending data

[oasd]

I'm having difficulty appending data.
I have an import macro (using the Transferspreadsheet function) to import
data from an excel spreadsheet (located in a USB attached to the pc) to an
access database.
The data in the USB has addtional info to be added to the respective record
in the database. The problem is that the data is not appended to the
existing record but merely added as an extra record.....effectively giving
me a duplicate entry with extra info.
How can I append the data relevant to the existing record with no
duplication.
thanks.

[Nick Coe \(UK\)]

Create a unique index on the field (or fields) which make up
the duplicate. Insertions of duplicate data will then fail.

Alternatively you could import the data to a work table
which you empty first, create a query that deletes any rows
that duplicate data in your main table. Then append the
remaining rows from the work table to the main table.
--
Nick Coe (UK)
http://www.alphacos.co.uk/

In news:42**********************@news.optusnet.com.au ,
oasd typed:

I'm having difficulty appending data.
I have an import macro (using the Transferspreadsheet
function) to import data from an excel spreadsheet
(located in
a USB attached to the pc) to an access database.
The data in the USB has addtional info to be added to the
respective record in the database. The problem is that the
data is not appended to the existing record but merely
added
as an extra record.....effectively giving me a duplicate
entry
with extra info.
How can I append the data relevant to the existing record
with
no duplication.
thanks.