-
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
-
Hello locutus,
It is my not clear or it is an Access table.
If it is such a table you can easy:
1 goto the table window of Access,
2 select the table you want to copy,
3 press ^C ^V,
4 give a new name to the copied table
5 goto to design the new table
6 change all text to number format you want.
Is this what you want??
Michelle.
