As Dale has suggested, we really need to know your ultimate purpose, here. Copying the entire content from one Table to another violates the rules of Relational Databases. If you object is, indeed, simply to change the Datatypes of qty1 and qty2 from Text to Numbers you can do that in Table Design View; you'll receive a warning message that you may lose some data, but assuming that the data looks like 'numbers,' i.e. is all digits, that won't occur.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007