Supported Database Types

Desktop Designer supports multiple types of databases:

• Microsoft Excel

• Microsoft Access

• Microsoft SQL Server

• Text File databases

• Oracle databases

• MariaDB / MySQL

• OLE databases

• ODBC database

• Google Sheets

• Excel (Microsoft OneDrive)

Loftware recommends using standard database types such as Text, Excel, Access, SQL Server, and MariaDB / MySQL. The use of standard database types is easier and more time efficient due to optimized application performance and user interface. When working with a non-standard database type, use the OLE and ODBC options.

Read about how to connect to the supported database types here.