My APPEND QUERY (for an extremely simple table) does not work (1 Viewer)

rtan2010

New member
Local time
Today, 12:30
Joined
Feb 6, 2020
Messages
3
I had documented my problem in the attached 3-page PDF file which includes all the relevant screenshots and procedural details.
I'd be grateful for any useful advice, tips or suggestions.
Many thanks.
 

Attachments

namliam

The Mailman - AWF VIP
Local time
Today, 06:30
Joined
Aug 11, 2003
Messages
11,541
Check all your other fields that you are not importing and make sure they are not set to "required"
Have null allowed and dont have a unique index on them.
 

The_Doc_Man

Happy Retired Curmudgeon
Local time
Yesterday, 23:30
Joined
Feb 28, 2001
Messages
16,798
The error message is clear enough. It didn't like what you were doing with a keyed (i.e. has index) field. You might need to compact & repair the database just before you perform the Append because that forces re-evaluation of everything including indexes. It also resets autonumber fields to the correct "next value" and assures that an appropriate value can be derived for such fields.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom