>and what about speed ?
>I made a test and seems like append was 4 to 10 times slower
I wouldn't comment on that. From test to test one might be faster than the other. My reasoning is simple:
select myTable
Append Blank
replace field1 with m.somevalue, ...
vs:
insert into myTable (field1, ...) values (m.somevalue, ...)
latter is a single atomic operation. Insert into also have variations like "insert into ... from memvar|array".
It has been a long time I don't use 'Append Blank'.
Cetin