Defining an ODBC Data Source (Magic xpa 4.x)

Objective

How to define an ODBC data source, such as importing data from Excel.

Solution

1. To import data (such as from Excel), run the ODBC administrator by typing odbcad32.exe in the command line.
   
   
   

2. Click the Add… button.
   
   
   

3. Choose the data source (ex. Microsoft Excel Driver).
   
   
   

4. Give the Data Source a name. And click the Select Workbook... button.
   
   
   

5. Select a workbook.
   
   
   

6. Add a database.
   
   
   

7. Give the database the same name given to the database in the ODBC administrator, and in the DBMS column, select ODBC.
   
   
   

8. Open the Data repository in the destination project. Park on the “Zero Line” (#) and press F9. Select the Database and set Tag Data Sources to All. Click OK.
   
   
   

9. Define one column or unique combination of columns as an index (make sure it is Unique).
   
   
   

10. Make sure that the column chosen is set to Null Allowed = No.
    
    

The data source is now imported.