Create an append query

  • Thread starter Thread starter Brigitte
  • Start date Start date
B

Brigitte

Hello,

I would like to copy the data of one table to another table (B). So I made
an append query but it didn't work. The properties of the fields are the
same, but nothing happens. Can somebody help me ?
 
hi Brigitte,
I would like to copy the data of one table to another table (B). So I made
an append query but it didn't work. The properties of the fields are the
same, but nothing happens. Can somebody help me ?
Click to expand...
You need to either press the exclamtion mark in the design view or
exceute the query from the database window to append your data.

Did you add any criteria to filter your data?


mfG
--> stefan <--
 
Could be several things. Can you go into SQL view of your query and copy the
statement here?
 
It may be that the records to be append will break some constraint (no dup,
no matching value in a foreign reference).

If you append the records from the user interface, rather than by code, do
you get some message? You may got no error message if you set the warnings
off (with a macro, or otherwise). If you use CurrentDb rather than the user
interface and execute an SQL statement, do you use the dbFailOnError
optional argument?

Current.Execute "INSERT INTO ..", dbFailOnError



Vanderghast, Access MVP
 
The data you want to append may break a constraint. If you are using the
User Interface, be sure the Set Warnings is set on, so you can get some
'error message' telling about a problem, if there is one occurring.




Vanderghast, Access MVP
 
Back
Top