Hi all
I am trying to use odbc to pull information from a progress table to UPS worldship. My problem is that my fields are all named with dashes ie.(ship-to-name) and UPS will not let you map fields with dashes. What I tried was to pull the information into access and rename the fields. This works but I cant figure out a way to make it live. I would have to re-query the progress table everytime I added a shipping record and that defeats my purpose. I tried linking the table but I access wont let you rename fields on linked tables. Renaming my fields in the progress database is not an option either. I need some middle tier with different field names. If anyone has any ideas please shoot them at me. Thanks.
I am trying to use odbc to pull information from a progress table to UPS worldship. My problem is that my fields are all named with dashes ie.(ship-to-name) and UPS will not let you map fields with dashes. What I tried was to pull the information into access and rename the fields. This works but I cant figure out a way to make it live. I would have to re-query the progress table everytime I added a shipping record and that defeats my purpose. I tried linking the table but I access wont let you rename fields on linked tables. Renaming my fields in the progress database is not an option either. I need some middle tier with different field names. If anyone has any ideas please shoot them at me. Thanks.