How to register an Excel spreadsheet as an ODBC datasource
Create a folder with 2 sheets. The first sheet holds a PUPILS (or STUDENTS) table, the second a STAFF table.A table is an array of cells whose first line describes the format and contains the names of fields ( columns ) : here NAME, FIRSTNAME, GROUP. The next lines contain the data. The table must be named : select the area that matches the table, including the first line, then Insert a Name, Define and type PUPILS for the first table et STAFF or the next.
The database can then be imported from the File menu, Import an ODBC source .
See Procedures