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

Appending data...

P: n/a
When I try to append one table to another with the exact same field
names I get an error...

Microsoft Access was unable to append all the data to the table.

The contents of fields in 0 record(s) were deleted, and 0 record(s)
were lost due to key violations.

*If data was deleted, the data you pasted or imported doesn't match the
field data types or the FieldSize property in the destination table.

*If records were lost, either the records you pasted contain primary
key values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?

What is causing this message? When I append, I am only missing 3 out
of 342 rows... Where should I check to fix this issue?

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

<ky***@mvlhawaii.com> wrote in message news:11*********************@o13g2000cwo.googlegro ups.com...
When I try to append one table to another with the exact same field
names I get an error...

Microsoft Access was unable to append all the data to the table.

The contents of fields in 0 record(s) were deleted, and 0 record(s)
were lost due to key violations.

*If data was deleted, the data you pasted or imported doesn't match the
field data types or the FieldSize property in the destination table.

*If records were lost, either the records you pasted contain primary
key values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?

What is causing this message? When I append, I am only missing 3 out
of 342 rows... Where should I check to fix this issue?


The very first thing I would like at is the table that you are pasting into, namely:

-indexes: does the paste create any double entries where each value should be unique
- zero length entries - are fields required
- primary keys

I am almost 100% sure that there is a violation taking place with one of the rules above.

You can fix this by
a. changing the rules, indexes, etc.. of the table that is pasted into
b. changing the data that you are pasting into the table (e.g. if you make it a "totals query" then only unique combinations will be
added.

HTH

let me know how you get on.

- Nicolaas
Nov 13 '05 #2

P: n/a
I have encountered this problem.

For example:
table 1= table 2 both use autonumber.
Table 1 has 3 records (autonumber 1,2,3)
Table two has six records.(autonumber 1,2,3,4,5,6)
If you add Table 2 to table one you will still only end up with six records
but will get the error message you talked about. The added table will have
records 1 2 3 from table 1 and 4 5 6 from table two.

If you add table 1 to table two you will end up with the same six records as
table 2
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Ab*********************@news.xtra.co.nz...

<ky***@mvlhawaii.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
When I try to append one table to another with the exact same field
names I get an error...

Microsoft Access was unable to append all the data to the table.

The contents of fields in 0 record(s) were deleted, and 0 record(s)
were lost due to key violations.

*If data was deleted, the data you pasted or imported doesn't match the
field data types or the FieldSize property in the destination table.

*If records were lost, either the records you pasted contain primary
key values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?

What is causing this message? When I append, I am only missing 3 out
of 342 rows... Where should I check to fix this issue?


The very first thing I would like at is the table that you are pasting
into, namely:

-indexes: does the paste create any double entries where each value should
be unique
- zero length entries - are fields required
- primary keys

I am almost 100% sure that there is a violation taking place with one of
the rules above.

You can fix this by
a. changing the rules, indexes, etc.. of the table that is pasted into
b. changing the data that you are pasting into the table (e.g. if you make
it a "totals query" then only unique combinations will be
added.

HTH

let me know how you get on.

- Nicolaas

Nov 13 '05 #3

P: n/a
1. Don't try to append autonumber fields. The receiving table will
automatically generate autonumbers for the appended records.
2. Be sure the data types match for each field between table1 and table2.
<<the data you pasted or imported doesn't match the field data types>>

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<ky***@mvlhawaii.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
When I try to append one table to another with the exact same field
names I get an error...

Microsoft Access was unable to append all the data to the table.

The contents of fields in 0 record(s) were deleted, and 0 record(s)
were lost due to key violations.

*If data was deleted, the data you pasted or imported doesn't match the
field data types or the FieldSize property in the destination table.

*If records were lost, either the records you pasted contain primary
key values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?

What is causing this message? When I append, I am only missing 3 out
of 342 rows... Where should I check to fix this issue?

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.