Linktables and queries.

[buggy2]

I am working on a database, which has 2 link tables linking to excel spreadsheets. I am trying to sample data from both tables. I have created a make table query which selects the relevant data from the first, and an append query which appends the relevant data from the second table into the table above. On running the make table query the first time all is ok, however when I try to re-run the make-table query I get a 'Numeric field overflow' error, which remains unless I re-save the query. Any ideas all the field numeric fields seem fine even looking beyond the first 8 rows of data.

 

[bat17]

At a guess it is creating a table with the wrong numeric data type. try just deleting the records rather than deleting the table and then append records from both tables.

HTH

Peter