Meant to type HOW to format...not WHO to format... haha
I'm trying to search on this, but I don't even know the words to use for the search so I haven't had much luck.
I have two excel files that I want to import (I know how to do this)
There is a relationship between the two tables, but the data in those columns is not in the same format
Sales Order number
Table1: 16/123456
Table2: 123456
Can I remove the 16/ from the one column during import, or do I need to do this manually before the import? This is something I do daily, so a macro, or formatting in Access would be ideal
I also have to change another column (actually 6) that are a direct export from SAP. It's spitting out dates like '12/12/16 rather than 12/12/16. I convert this with "text to column" in the data tab in Excel, but again, I'd rather have a more automated process.
If someone has an easy solution, I would appreciate it. But ideally I'm looking for the what this would be called so I can research it and learn for myself.
Thanks!