Link to home
Start Free TrialLog in
Avatar of truth_talker
truth_talker

asked on

MS Access ODBC Import Issue

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.
ASKER CERTIFIED SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of truth_talker
truth_talker

ASKER

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