Second request for help

[John Alban M]

Apparently this is a very rare problem because my first request was not
replied to. If there is more information that you need to determine how to
help me fix my problem, please feel free to ask.

As I previously stated on 2/9/05:

I am trying to import a table from an ODBC source and Get an error "Invalid
Scale for Decimal Data Type" and can only select "OK" or "HELP". HELP is
useless. Does any one know how I can overcome this error?

Additional Info:

I am trying to import a table using MS-Access.

I believe the data tables I am pulling from may have a field with a floating
decimal that access doesn't know how to handle. I can do a database query in
EXCEL against the same tables and pull the data down fine. This is ok until
the table contains more than the 65k lines of data, then Excel becomes
useless.

Any response is better that none. Thanks.

John

 

[Tom Gaughan]

Have you checked the fields in Access that are type Decimal? If you have
any that are Decimal type check the Scale property of that field. The
default Scale on a Decimal type is zero. Try bumping up the Scale or maybe
better yet change the field to Double.
Tom