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:
You don't have the appropriate permissions.
No, open a new Support Case