Invalid scale for decimal data type

  • Thread starter John in St Louis
  • Start date
J

John in St Louis

I am trying to import an ODBC data base (SQL) to an ACCESS table. For most of these database imports there is no problem, however, sometimes I get a message box titled "Forms Processing" with a message that says "Invalid scale for decimal data type" and 'OK' & 'Help' buttons. Often, I can do a database query in EXCEL to circumvent the problem, but this data is to big to fit in EXCEL, does anyone know a way around this through ACCESS?
 
Top