I need to change the data type for a field in order to make some outer joins work, but the field in question comes from a linked table. There is too much data to change the data type in the actual table that is linked so I need a workaround.
So far I do it like this:
- Copy and paste linked table as structure only
- Change the field data type in the new table
- Append from the linked table
This way my queries that have outer joins will work. I don't want to do this manually though so is there a way to put this into a macro somehow? Or maybe a better workaround than what I'm doing here?