When using Excel database, the "Database login" dialog box pops up
Article ID: 136 - Updated: Feb 15, 2021 - Products: Designer PowerForms, Designer Pro - Version: V6 - Category: License and Activation
You do not have the Microsoft Office data access components installed on your computer. Without the data components, the applications cannot access the data in Excel files.
Install Microsoft Office 12.0 Access Database Engine OLE DB Provider. Download it from Microsoft Web site.
Also see the KB article Connectivity to Office documents on 64 bit platforms.