Access Programmer Houston Texas – Example of an ETL Process in MS Access

Access Developer 4 Hire built a CRM Db for a Houston, Texas business, Coldwell Banker Richard Ellis. CBRE is the world’s largest commercial real estate services company. Large companies often perform ETL tasks with complex and costly software specific to ETL tasks, such as Cognos. ETL stands for Extract, Transform & Load. ETL refers to taking data out of one source, changing it somehow, and then loading it into a new location. But, as shown below, an MS Access programmer for Houston, Texas, can create custom ETL tasks with VBA code.

Excel imported into Access – the most common way a database is born.

The most common way an Access database comes into being is from an Excel spreadsheet. But when Excel records are not all in rows, like a table, they will not easily import. Retyping the Excel data into a database, in most cases, is too time-consuming and risks errors in the form of typos. Therefore, importing Excel data using custom business logic allows for precise and fast loading of database tables. Sometimes, it is required to split data from each MS Excel record into more than one database table during an import. A customer ETL routine written in VBA can achieve the data split.

In our ETL example, VBA code tests every record moving from an Excel file into the CRM database. When business logic raises a red flag, the Import Decision form allows the user to decide how to proceed. Also built into this process is a feature enabling corrections to edits made in the Import Decision form. The user can click on a given record and see a complete history of changes that have taken place. The user can then select a button to bring back an older version of that record.

If you need an Access programmer in Houston, Texas, please call us at 512-202-7121. We have built new databases from the ground up and fixed or enhanced existing databases for the greater Houston area for many years. We look forward to hearing from you.