During Import-force single data field from text to numeric - Help?!

Tech-Archive recommends: Speed Up your PC by fixing your registry

I need your help people.

I have created a macro to import bunch of database files from the AS/400. Purpose is to move away from AS/400 to Microsoft Platform system.

One if the database file has a unique field. In the system (AS/400) it is a numeric field but actually it is text when imported from AS/400 to Access.

How do I force the import task to make that 1 field numeric?

Originally, when I manually imported the field, I changed the field from text to numeric, it gave a warning saying that any data that is text will be removed, and I agree with that and voila it is a nice clean database in Access.

Now I want the Import to force the field to be numeric than text.

Do you have a solution?

Thanks in advance..

Gil
.