The VBA SQL Client Data Integration System is designed to streamline the process of retrieving and managing client information within an organization. This project features a robust class module that establishes secure connections to SQL databases, executes SQL queries, and automates the extraction and transformation of client data. By leveraging VBA and ADODB, this system eliminates the need for manual input by users, specifically removing the manual process of copying client information from AS400 black screen to generate desired output. This system enhances operational efficiency, reduces errors, and ensures seamless integration of client data into required business processes.
To utilise the system user are required to:
- Open Visual Basic on Developer tab.
- Open Module1 and input specific client ID on line 50.
- Open class module, input driver's name and system name where the databse to be extracted on line 68 or 72.
- The SQL code can be edited on Sheet1.