We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I performed some basic data conversion but I am not sure if I should choose Access or stick with excel? Below are some high-level requirements -
- This is one time data conversion during the software switch.
- Less than 100k lines per tab and probably 5 to 10 tabs
- Convert the legacy data to new data with help of mapping logic; for example customer numbers from legacy system will be converted to new customer numbers with help of cross reference data and similar to this there are other cross referencing.
It involves lot of looping of each sales order with respect to the cross referencing data.
Data layout has to formatted in specific way so that it can be uploaded to new software.
Let me know if any other details are needed.