Excel - How to define a name to source data ?

Card Puncher Data Processing


To source data from an Excel file, you must define a name for the range of data being sourced:

  • In the employee worksheet, highlight the range that you want to query from Oracle. The range should include the column names and the data. Ensure that the column names confirm to the rules for naming columns in the Oracle database.
  • Define an Name :
    • For Excel 2003 : From the Insert menu, select Name and then define
    • For Excel 2007 : From the Formula menu, select Define a Name

Hs Odbc Excel Define Name

Then you can perform with the help of ODBC - Open Database Connectivity a sql statement as :

select Id, Name from Employee

Name Manager

You can manage the existing name with the Name Manager.

In Microsoft 2007 > Tab Formulas > Name Manager


Insert Statement

insert into [Sheet1$] (id,name) values(5,'Nico')

Discover More
Card Puncher Data Processing
Microsoft Excel

Excel is a spreadsheet tool that you can categorize in the desktop database. It's a reactive tool (a cell update is reflected in all dependent cell). Lukas...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...

Share this page:
Follow us:
Task Runner