Numeric overflow

[mart10]

I am using Access 2003

I run a macro of about 25 queries each looking at different linked spreadsheets to append data to a table. And note it also has an initial query to clear the table

The first time it runs it works fine. However if I run again I get numeric overflow

 

[Andrzejek]

There is no question in your post. But if you want some help, show the code that you have a problem with, including the declaration of any variables you use.

Have fun.

---- Andy

 

[SkipVought]

However if I run again I get numeric overflow

On what statement?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mart10]

The code runs through a macro. i GET ROUND THE ISSUE BY RELINKING THE SPREADSEEHTS