By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,743 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,743 IT Pros & Developers. It's quick & easy.

appending data

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.