Software

Ask something
Discussion Locked

Importing to Access with ODBC

0 helpful
12 replies

by bytemi 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been importing ODBC tables into Access 2000. When I try to create a table with the data using a query, I get the following message:

"The decimal field's precision is too small to accept the numeric you attempted to add."

I have the latest Jetform service patch and I downloaded the latest MDAC and nothing is working. Can someone help solve this??

Adele

12 replies

by bytemi

I have seen these site and tried them, the updates have not helped. One of the posting stated that unlinking the FoxPro tables would solve the problem, but as far as I know you can not unlink a table in access. Please let me know if you know how to do this.

by mvegas

Have you checked to make certain that the data types within Access are properly set for the data types your pulling in?

Your error message seems to imply that the data type in Access isn't properly set for the data it is trying to store.

by mslizny

Tools, database utilities gives you the Linked
Table Manager. While this is usually used to
re-link tables to a source that has moved, you
can also use it to un-link tables, however, the
person who mentioned that you are likely
trying to import un-compatible data types is on
the right track. Look in the design view of your
tables and see if the number type of the field
is set for the same decimal value as the
information you are trying to bring in.

by wanderson

You can in fact delete linked table. Simply highlight the table and press DELETE.

You check the data type by opening the table in DESIGN mode and looking at the field's data type.

This discussion is closed to new replies.