I am trying to import some data into MS Access from an ODBC Connection.
I am having two issues.
#1 - Whenever the data is importing, I keep getting this error.
Scaling of Decimal values resulted in data truncation.
Is there a way to make access skip over the errors, so I don't have to press this hundreds of times?
#2 - The data goes back 11 years, but I only need 2 years worth of information.
Is there a way to make it only import data from a certain date forward?
I'm guessing that would be based on a value in the tables, so that may be a little more complicated than I want to handle.
But if I can get #1 fixed, I can leave it running for hours and not worry about click on OK all the time.