Import Data into existing tables

[Johnrg]

Hi Guys,

I am a new user so please go easy on the computer speak!

I have two linked tables in a updated version of an existing database we use.

The tables and all feilds are the same in both databases and are called customers and customerdeliverynames.

I am trying to import data from the above tables in our old database into this new newer version.

I have created an append query but keep on get violation rule prompts and no data imports.

I have tried exporting the info into a spreadheet and importing that way but still no luck.

What am I missing here?. The tables and all feilds are the same?

Thanks

JohnG

 

[MSAccessRookie]

Hi Guys,

I am a new user so please go easy on the computer speak!

I have two linked tables in a updated version of an existing database we use.

The tables and all feilds are the same in both databases and are called customers and customerdeliverynames.

I am trying to import data from the above tables in our old database into this new newer version.

I have created an append query but keep on get violation rule prompts and no data imports.

I have tried exporting the info into a spreadheet and importing that way but still no luck.

What am I missing here?. The tables and all feilds are the same?

Thanks

JohnG

Without additional information, I can only make a general guess. Given more information, I might be able to make more specific comments.

When there is a field (primary key?) that must be distinct, an Append Query can only add a record when there is not already a record matching the data that is being appended. If the record already exists, it will either need to be ignored (if it is the same) or you will need to perform an Update Query (if the record has changed).

Hope this information helps.

 

[Magster]

Do you have any unique indexes in your database tables? If so, you may be trying to append new records that will cause duplication and the query will not append new rows.

Magster

 

[Mike375]

What I usually do with this sort of things is:

1) Run a Maketable query on the tables you are trying to append to. The new tables will lose various attributes that have been set for different fields. I don't know if they lose all of them but it has always allowed me to append records.

2) Rename the original tables to whatever and rename the new tables to the original table names. Or rename the original tables and run the Maketable query on the renamed table and give the new table the original table name.

Then run your append query. If all the records now append then you know for sure where the problems is.