How to convert alpha text into numeric?

Data is in a delimited file. I have a conversion table built in Excel mapping text into numeric equivalent (using dept names on one system that needs to be numeric for import into accounting GL system -- Great Plains). Have Excel & Access but not experienced with Access. Thanks,

Related Workshop Websites

    One Response to “How to convert alpha text into numeric?”

    1. Jan O says:

      In Excel you use the VALUE() function to do this. I would think Access has a similarly named version of that.

    Leave a Reply