none
Excel 如何连接到远程ORACLE数据库? RRS feed

  • 问题

  • 客户端我安装了PLSL Developer,TNS配置好了,

    请问如何通过EXCEL VBA来连接ORACLE?

    麻烦了,谢谢!

    • 已移动 Carl Cai 2014年2月18日 1:17 More related
    2014年2月17日 8:40

全部回复

  • You can configure a ODBC connection and connect to Oracle.


    大家一齊探討、學習和研究,謝謝!
    MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP, MCPD,
    MCT, Microsoft Community Star(TW & HK),
    Microsoft MVP for VB.NET since 2003
    My MSMVP Blog

    2014年2月17日 9:23
  • How to cinfigure the ODBC on my Computer with WIN7 ? I don't want to install anything about oracle's product on my computer unless the installer is very small.

    Please show me the steps.

    Thanks & Best Regards.

    2014年2月18日 2:10
  • How to cinfigure the ODBC on my Computer with WIN7 ? I don't want to install anything about oracle's product on my computer unless the installer is very small.

    Please show me the steps.

    Thanks & Best Regards

    2014年2月19日 1:43
  • There are many solved posts talking about this Excel reading related issue. You can google as "excel vba code to connect to oracle database" Then there will be several similar topics on the Excel connecting problem, like

    http://www.vbaexpress.com/forum/showthread.php?40986-Solved-Connect-to-Oracle-Database-using-Excel-VBA

    2014年4月24日 7:35