Need help on Numeric field overflow error

[J Cole]

Hi,

I have linked an excel file using File -> Get External Data -> Link Tables
and trying to insert a few records into a table, tbTest (say)
tbTest has ID (AutoNumber), empID (integer), BatchID (integer), name (text)

Insert query:
---------------
INSERT INTO tblJobParts ( empID, BatchID, name )
SELECT Originaldata.[Emp Id], Originaldata.[Batch ID(1)], Originaldata.[Emp
name]
FROM Originaldata
WHERE Originaldata.[Emp Id] is NOT NULL;

When I execute the above query, I get an error (as below):Numeric field overflow. (Error 3349)
The data in a Btrieve field is too large to represent in your application.
<<<<

Kindly note that there are only about 50 rows in the excel file.

If I just execute the select, it returns the 50 records. Could someone let
me know what I'm going wrong?

Appreciate any help.

TIA,
Cole

 

[Gary Walter]

I don't understand where Btrieve fits in, but...
this may help:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q815277

I have linked an excel file using File -> Get External Data -> Link Tables
and trying to insert a few records into a table, tbTest (say)
tbTest has ID (AutoNumber), empID (integer), BatchID (integer), name
(text)

Insert query:
---------------
INSERT INTO tblJobParts ( empID, BatchID, name )
SELECT Originaldata.[Emp Id], Originaldata.[Batch ID(1)],
Originaldata.[Emp
name]
FROM Originaldata
WHERE Originaldata.[Emp Id] is NOT NULL;

When I execute the above query, I get an error (as below):Numeric field overflow. (Error 3349)
The data in a Btrieve field is too large to represent in your application.
<<<<

Kindly note that there are only about 50 rows in the excel file.

If I just execute the select, it returns the 50 records. Could someone let
me know what I'm going wrong?

Appreciate any help.

TIA,
Cole