Create a Named Ranged in a Spreadsheet to access via ODBC

 

To create a named range in a spreadsheet:

1. Open Microsoft Excel and create a new spreadsheet.
2. In the first row of the spreadsheet, type the column names, such as: cusnum, item, desc, and so on.
3. Highlight each of the columns in the first row that will be used in the named range.
   
4. In the menu, click Insert > Name > Define.
5. Type a name for the range. For example: ItemList
6. Click OK.

The name you just created is the table name when performing ODBC operations against the selected spreadsheet.