Transferring Data from linked Excel into Access table via query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
When I use an insert query to insert data from excel into access table the
error: "Numeric Field Overflow" occurs.
Please help
 
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 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.
 
Back
Top