def convert_data_type(self, datatype):
"""MS Access can't handle complex Decimal types"""
converted = Engine.convert_data_type(self, datatype)
if "NUMERIC" in converted:
converted = "NUMERIC"
elif "VARCHAR" in converted:
try:
length = int(converted.split('(')[1].split(')')[0].split(',')[0])
if length > 255:
converted = "TEXT"
except:
pass
return converted
