Page History

Using ODBC

This method option offers a standardized and widely supported method for connecting various applications to databases, ensuring . As a result, it ensures compatibility across diverse data sources. See In the following sections below to learn how to connect the platform with an Excel file in different Microsoft Excel you find guides to connect to different Microsoft Office versions.

Microsoft Office 365

To connect to a datasheet in Office 365, follow the steps below:

1. Select the the cells to use as data.
2. Access Formulas → Define Name.
3. Choose Select Define Name.
4. Name Define a name for the selection (for example ItemsTable) and the . The Excel file is will be ready to be useduse. 

Microsoft Office 2007

To connect to a datasheet in Office 2007, follow the steps below:

1. Select the the cells to use as data.
2. Right click the selection and choose Name a Range.
3. Name Define a name for the selection (for example ItemsTable) and the . The Excel file is will be ready to be useduse. 

Microsoft Office 2003

To connect to a datasheet in Office 2003, follow the steps below:

1. Select the the cells to use as data.
2. Access Insert → Name.
3. Choose Select Define.
4. Name Define a name for the selection (for example ItemsTable) and the . The Excel file is will be ready to be useduse. 

ODBC Microsoft Excel Driver

The ODBC Microsoft Excel Driver provides a dedicated driver for Excel , ensuring to ensure optimal performance and seamless integration with the Excel file format. To connect using this method, follow the steps below.:

1. In the platform, access Access Datasets → DBs.
2. Click the plus icon.
3. Fill in the Name field
4. In the Provider field, select Odbc Data Provider.
5. Choose Microsof Microsoft Excel Database in the Database field. 
6. Click OK
   
   
7. In After returning to the data grid, click the Connection String column of related to the newly created row.
8. Enter the path and filename to the file in the Dbq field.
   Image Removed Use the Test button to ensure the connection is correctly configured.
   Image Added

ODBC With A DSN

Using ODBC with a DSN allows for centralized management and easier maintenance of data source connections, simplifying the configuration process. To connect using this method, follow the steps below.

1. Access your computer's Control Panel and search for ODBC Data Source Administrator.
2. In the "ODBC Data Source Administrator" window, click Add.
3. Select Microsoft Excel Driver (*.xls).
4. Click Select Workbook and choose the Excel file that was previously created.
5. Name the Data Source, . For example excelDatasource (For Write access, uncheck the Read Only checkbox).
   
6. Now back in Back into the platform, access Datasets → DBs.
7. When creating Create a new DB choose choosing ODBC Data Provider as Provider. For Database,select ODBC using DSN.
8. Click Ok OK.
   Image Modified
   
9. In After returning to the data grid, click the Connection String column of related to the newly created row.
10. Enter the DSN (Data Source Name) in the DSN field.

In this section...