Change the name of a field and/or it's data type in a macro?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am trying to write a macro to import data from another db into Access. I
then need to change the names of some of the fields (they are pretty cryptic)
and I also need to change some of the data types. They all come over as
text. Can this be done in a macro?
.