Configuring ODBC to access the document Excel (*.xls)

Print Top page
  1. Open the Excel document, select in it the desired cell range (all may be) and give it a name, for example, ExampleExcel. To name a specified range of cells in the Insert menu, click Name and then Define. In the appeared window enter a name. Then save and close the document. Now, you get access to the range you selected. In one Excel document there can be several such ranges with the assigned names. Each of them can be accessed from the program by specifying the name of the range.
  2. Start program the Data Source Administrator.
  3. In section User DSN or System DSN click Add button.
  4. In the appeared window choose Microsoft Excel Driver (*.xls) and click the button Finish.
  5. There will be a window with properties of the Data Source. Enter a name of a source (Data Source Name), for example, ExampleExcel.
  6. Press the button Select Workbook and choose the necessary file.
  7. Click Ok. Once again Ok.
  8. In the program, in section the Data Source select the data source you created (ExampleExcel).
  9. If for access to the document it is required to enter a name and password, enter them in the appropriate fields.
  10. Check the workability of the created data source.