[AccessD] Strange append query execution Access to Oracle ODBC

Benson, William (GE Global Research, consultant) Benson at ge.com
Tue Jul 31 00:01:09 CDT 2012


Part 2:  I can only find a way to import text files into SQL developer using the menu - does anyone know if this can be scripted for unattended completion of insertion of several text files' worth of data into corresponding oracle tables?


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William (GE Global Research, consultant)
Sent: Tuesday, July 31, 2012 12:32 AM
To: Access Developers discussion and problem solving (accessd at databaseadvisors.com)
Subject: [AccessD] Strange append query execution Access to Oracle ODBC

I have an accdb which in which oracle tables are linked using odbc. I was inserting into one of the oracle tables all the records from a local Access table. The query was taking a very long time, for under 10K records, about 10 columns. Strange thing was, I checked the oracle table using SQL Developer early on in the process and it seemed like the data was there lickety-split. I saw the full record count, and did check the actual data, which looked fine. Not sure if it was complete. I don't know how odbc works. I am confused what Access seemed to be waiting for, rather than announcing the query completed. The status bar was very slowly creeping from left to right.

At some point, I hit the Escape Key because I deemed it just wasn't worth the wait, and I figured I could export the access tables as text files, then import them into SQL Developer.

The strange thing is not only that all the records appeared to be in Oracle WAY before the query finished running, but after I hit Escape (which therefore meant I would not get a prompt about whether or not to allow the insert to be done, which one normally gets at the end of query execution), the data really did appear to be in Oracle, with no opportunity to cancel the insert.

Can anyone tell me what might be going on in this situation?

I have since deleted the data in Oracle because I just don't trust this process to have completed successfully.

Thanks

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list