Importing from Excel using a linked File and an Append Query

R

rms

I previously was importing data into my main data tabile via a linked excel
file which would be updated daily and an append query, and it has worked fine
for months.

I made some modifications to the database and now when the append query is
run it generates a "Run Time Error '3349' Numeric Field Overflow. What is
this? Why am I getting it and how do I fix it? How do I figure out which
field is causing this?

If I copy the data from excel and paste it into the table it works just
fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top