Hi all,

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?

Thanks!