MS Access Database with External Data - Microsoft Access 2003 Overflow Error

Author

Microsoft Access 2003 Overflow Error

SimplyClassyJack

2005-08-29, 8:27 pm

At this moment, I imported some tables from ODBC Databases into Microsoft
Access, made some changes, and trying to export them back to Oracle Database.
I had about 10 tables imported and every table except one table had no
problem exporting. But when I try to export the last table, there are two
different error messages coming up from two different machine (I made a copy
of file and tried on different machine and still was unsuccessful). Those
error messages are

1) Overflow Error
2) This expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many complicated
elements. Try simplifying the expression by assigning parts of the expression
to variables. (Error 3071)

The help doesn't exactly help me. Can someone please help me?

Ken Snell [MVP]

2005-08-30, 8:29 pm

What types of data are you exporting? What are the values? What is the SQL
statement of the query? Those errors can arise from a number of sources --
trying to put a number larger than Integer size into an integer, having an
incomplete "date string" as a date value, trying to divide by zero, etc.

--

Ken Snell
<MS ACCESS MVP>

"SimplyClassyJack" < SimplyClassyJack@dis
cussions.microsoft.com> wrote in
message news:55701F8A-78B7-4A00-8270- 13DF06CF83AF@microso
ft.com...
> At this moment, I imported some tables from ODBC Databases into Microsoft
> Access, made some changes, and trying to export them back to Oracle
> Database.
> I had about 10 tables imported and every table except one table had no
> problem exporting. But when I try to export the last table, there are two
> different error messages coming up from two different machine (I made a
> copy
> of file and tried on different machine and still was unsuccessful). Those
> error messages are
>
> 1) Overflow Error
> 2) This expression is typed incorrectly, or it is too complex to be
> evaluated. For example, a numeric expression may contain too many
> complicated
> elements. Try simplifying the expression by assigning parts of the
> expression
> to variables. (Error 3071)
>
> The help doesn't exactly help me. Can someone please help me?

SimplyClassyJack

2005-08-31, 3:26 am

I actually found what was the problem. There's part of the data where I enter
the date.

"During a discussion of SQL dates, Andy Winningham pointed out:
Another thing to remember about going from Access to SQL Server
regarding data conversion is that a valid date in Access may not be valid in
SQL. For example, Access will treat the date 01/01/200 as valid. However if
you try and load this date into a SQL Server database, you will get an
overflow error."
(http://www.vb-helper.com/ bug_sql_d...lo
w.html)

And I had a single data that had 104 as its year.
Thanks.

"SimplyClassyJack" wrote:

> At this moment, I imported some tables from ODBC Databases into Microsoft
> Access, made some changes, and trying to export them back to Oracle Database.
> I had about 10 tables imported and every table except one table had no
> problem exporting. But when I try to export the last table, there are two
> different error messages coming up from two different machine (I made a copy
> of file and tried on different machine and still was unsuccessful). Those
> error messages are
>
> 1) Overflow Error
> 2) This expression is typed incorrectly, or it is too complex to be
> evaluated. For example, a numeric expression may contain too many complicated
> elements. Try simplifying the expression by assigning parts of the expression
> to variables. (Error 3071)
>
> The help doesn't exactly help me. Can someone please help me?

Sponsored Links