Update query appends nil records

[captnk]

I have imported some delimited text files into a table.

The delimted text has no headers and Access gave each field a name,F1,F2,F3 etc

I have a nother table with correct field names,and have written an update query.

IT RAN ONCE,and appended about 1/3 of the total items.
Since then it refuses to append any records
(THe receiving table is empty by the way).

I have checked that all fields r the same type etc,their is no primary key field.

I can cut and paste manually so the columns are fine.
I guess thats an alternative,if someone could pls suggest some appropriate VBA code that simply cuts and pastes.
Any help appreciated

 

[RV]

Post your statement.

RV

 

[captnk]

Oops Sorry folks!!
I think I had a complete mental block on this.
I have achieved the Update using a straight append query.

Thinking logically (In a new day),I guess the quey couldnt update because there was nothing in the receiving table to update.