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.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: July 03, 2020