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
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