Import to Oracle

D

Dar

I have a table in my Access 2002 database, which has about 60000 records, that I'm trying to export into one of my Oracle(version 8.1.7) tables. I have linked my access table to the Oracle table and I am trying to run an insert statement from my access table into my oracle table. However, when the query finishes executing, I get a Access message that says 'Overflow' and nothing else

When I check my Oracle table to see if the data got sent to it, the data is not there. What does the message 'Overflow' that Access is giving me means and how do I fix it

Thanks,
 

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

Linking Access and Oracle Database 2
oracle fields exceed 255 3
Mail Merge file containing a Word Table 0
Access 2007 ODBC for Oracle linked table issue 1
Problem connecting Access to Oracle 0
Append Crosstab Query to Existing Table 0
Help creating a search form in Access XP 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top