Import in Access XP ---> Oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Oracle 8 database on the server is an field with as number. The table
gives the follow numbers: 129,10 ; 118,11

When I make in an MS Access database an import with ODBC then gives me Acces
the follow numbers: 12910 ; 11811

When I make a query with MSQuery with the same ODBC then gives me MSQuery
the follow numers: 129,10 ; 118,11

Who can help me.
 
I have the exact same problem. However I have one PC where it's ok and
another where I get the described error. That is I open the Access database
on one machine and its ok and then I open the same database on another
machine and the decimal separators dissapear.

The 2 PC have the same versions of Access with the same settings.

Martin

"Jan" skrev:
 

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

Similar Threads

MS Oracle ODBC failure in Access 07 3
Access 2003 not linked to Oracle 11g 3
Linking Access and Oracle problem 4
Export an Access table to an EXISTING Oracle Table 1
Oracle ODBC Connection Problem 1
ODBC Connection to Oracle not working on Vista 1
Excel-MSQuery Out Of Memory error 0
oracle sql plus - modified table column - not showing in Access 1

Back
Top