Went I first link to an excel spreadsheet and I use an action query to update the values in another table it works fine. The trouble happens when I attempt to re-append the data from the same excel spreadsheet, I am receiving a "Numeric Field Overflow" Error message each successive time I attempt to run my action query. THe only work around that I was able to figure out was to unlink and then re-link to the excel spreadsheet prior to runing the action query.

I am wondering if I can use VBA to un-link and then re-link each time I run this query?

Thank You,