Hi OBP,

I've re-attached a new db file with data. There are 267 fields for both tables. No problem to split into 2 tables of 133 and 134. I would prefer to have VBA code to create them.

tks a lot!