Tuesday, June 28, 2011

64 bit ODBC issues (ODBC Import PL/SQL Developer)

Was having issues attempting to get ODBC import to work in PL/SQL Developer.


I'm currently running Windows 7 64-bit and a 64-bit Office 2010 install.


In order to get ODBC import to work with PL/SQL Developer I had to:
  1. Open the 32-bit version of the ODBC administrator.
    1. This is tricky as most links/icons in the UI take you to the 64-bit manager.
    2. In my case, simply running c:\windows\sysWOW64\odbcad32.exe in the start menu search area brought up the right manager.
  2. Create a new system DSN using the Excel drivers it finds when you click "Add".
  3. Once that's there, you should find it in the listing for ODBC sources upon attempting to ODBC import from within PL/SQL developer.
Labels: , ,

2 comments:

  1. UnknownOctober 3, 2012 at 6:22 AM

    Hi,

    could you help me with this:

    I would like to import xlsx excel file with PL/SQL Developer to Oracle database.(Iam running windows 7 64-bit and 64-bit Office 2010 )

    Thanks
    George

    ReplyDelete
  2. SteveOctober 3, 2012 at 12:02 PM

    Gyorgy,

    All I see in the ODBC importer (select workbook window) is *.xls. That is likely a limitation of the IDE itself. You might inquire @ allroundautomations.com or you can simply save your .xlsx to .xls and import.

    ReplyDelete

Subscribe to: Post Comments (Atom)