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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

invalid scale for decimal data type 0
Invalid Scale for Decimal Data Type 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
access 2007 Error 3701 "Invalid Scale for Decimal Datatype" 0
Fraction to Decimal 2
Table Security in Access 2013 1
Export Text Wizard: Invalid Argument 0
Second request for help 1

Top