MS Excel Connection
It is used for connection to the Microsoft Excel file as to a database.
Connection Parameters
The following parameters are set during the connection setup:
- Caption contains the connection name set by a user.
- File name: the path to the file containing the required data is specified. Parameters can be manually entered, or it is possible to press
button to call Open file window. - Test: test of the specified connection settings.
- Show system tables: when selecting this checkbox in the import wizard that uses this connection, the system DB tables available to a user become visible.
- Quote names: if the database objects names (for example, names of tables, fields) contain spaces or reserved characters, it is required to use framing characters fixing the name start and end.
- Configure quotes represents the information field that enables to define which framing characters are used for connection to this DB. Double quotes are used for Microsoft Excel.
- Do not use DBMS client: it is not possible to change this parameter for Microsoft Excel.
- Clear pool when deactivated enables to clear the pool of the Megaladata Integrator packages frequently used in the batch processing saved for the quick call upon the node deactivation. This parameter is disabled by default.
- Comment: it is possible to provide any reference connection data in this form.
Compatibility
To connect to the files of Microsoft Excel 2007 and higher (*.xlsx), the system must include the following components matching the Megaladata server by bitness:
- Microsoft Excel 2007 and higher;
- Microsoft Access Database Engine 2016 Redistributable.
See also: