excel通过odbc访问excel

侠客刀

已于 2023-09-01 14:55:34 修改

阅读量772

点赞数

文章标签： oracle excel

于 2023-07-20 11:45:28 首次发布

本文为窦永厚原创文章，未经允许不得转载。

本文链接：https://blog.csdn.net/qq_33202508/article/details/131826974

版权

文章介绍了在Windows10上配置OracleODBC连接的详细步骤，包括下载instantclient-basic和oracle-odbc插件，将插件解压合并，编辑tnsnames.ora文件以设置数据库连接，配置环境变量，以及通过ODBC数据源管理器进行设置，最终在Excel中使用新连接。

摘要由CSDN通过智能技术生成

文章目录

1.下载oracle-odbc插件

https://download.oracle.com/otn_software/nt/instantclient/instantclient-odbc-windows.zip

2.下载instantclient-basic插件

https://download.oracle.com/otn_software/nt/instantclient/instantclient-basic-windows.zip

3.oracle-odbc插件解压放到instantclient-basic插件下

4.修改network\admin下的tnsnames.ora

DW01_177 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.xxx.xxx.xxx)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dw01)
    )
  )

DW01_175 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.xxx.xxx.xxx)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dw01)
    )
  )