I have a table where every field has been set up as a text field of 255 chrs ( default) this table has 80 fields.

I have set up a new table with exactly the same fields but the hane been set appropriatly and formatted:

heres and example

original table:
weight = text
length = text
cmt = text
reelno = text

new defined table:
weight = number ( double o.o)
length = number ( short integer)
cmt = number (double )
reelno = text

I want to transfer the contents of the original table which is all in text into the newly defined table. How do I do this , I tried an sql to select all and insert into new table but the message said something alond the lines of different data types. Same thing with cut and paste. How do I do this , anyone know ?

Many thanks
Locutus