Transferring Data from linked Excel into Access table via query.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joseph - 16 Aug 2005 22:21 GMT

Hi,
When I use an insert query to insert data from excel into access table the
error: "Numeric Field Overflow" occurs.
Please help

Reply to this Message

Klatuu - 16 Aug 2005 22:35 GMT

You have data in the Excel spreadsheet that is confusing Access. The problem
here is that if a cell in Excel is formatted as General and not data has been
entered, Access will see it as Null. There could be other issues with
numeric data type matching, but I have not experienced these.

To avoid the Nulls causing problems, wrap all your numeric fields in your
query with the Nz function. For example, we have a column in the Excel table
named SomeMeaninglessNumber, so in the query in the column where you are
using SomeMeaninglessNumber, in the Field row:

Exp1: Nz(SomeMeaninglessNumber,0)

> Hi,
> When I use an insert query to insert data from excel into access table the
> error: "Numeric Field Overflow" occurs.
> Please help

Reply to this Message

John Nurick - 17 Aug 2005 07:22 GMT

Hi Joseph,

It's possible that there's a value in a column in the Excel sheet that
is too large for the data type of the corresponding field in the table.
E.g. a Number (Long) field can't store values much over 2 billion, and a
Number (Integer) is limited to about 32,000.

>Hi,
>When I use an insert query to insert data from excel into access table the
>error: "Numeric Field Overflow" occurs.
>Please help

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message