We help IT Professionals succeed at work.

MS Access ODBC Import Issue

truth_talker
truth_talker asked
on
88 Views
Last Modified: 2017-11-18
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.
Comment
Watch Question

Microsoft Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
I actually have two databased.

One is Firebird, the other is an ODBC link to iCOBOL.

That's a bit over my head, but I will give it a try.
CERTIFIED EXPERT

Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Anders Ebro (Microsoft MVP) (https:#a42041198)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions