Category: ETL
-
Dynamic Report Heading in an Access Report
When I design an access report which can be used by multiple clients I code the report headings and the data selection for the months to allow the client to change this if required. In the sample above the client financial year starts on the 1st of March. They can set the column heading to…
-
Application Deployment
Application Deployment for Access or Excel Apps; When distributing apps I usually create an install program to setup the application correctly for the user. I use Inno setup which does a great job of packaging the files creating the user shortcut and ensuring they have installed the program into the correct location. When deploying these…
-
Auto Unzipping Files and Loading of Excel Files
We used this function for auto unzipping files , the Excel files had been sent by email and an outlook rule saved the attachments into a given folder The Unzipit function uses the Chilkat Component and Excel Automation to open and save the file into a specific folder and load the contents into an SQL…
-
Loading Files from a Folder
I use this function to load CSV, txt and Excel files as part of the ETL Process. An example of this function call is available within our sample app. The button “Import and Load” will first clear the existing data and then import any files which match the section name “Import Invoices” in the table…
-
Altova Mapforce
I am currently running a demo of the mapforce to review how the software works and how to implement the system. I am unclear at this time if the software will store the mapping and allow it to be called by an API to allow customisation of messages for individual customers. Ideally it will allow…
-
Importing Data into Access
A lot of my applications involve importing data into access from an external source, executing some transformation and applying business rules. When I first started using Access I would have written an import specification for each file, and then added queries or code to load the data and apply business rules. This approach involves a…
-
Viewing XML Files
I use Chilkat to make and read XML files. I like the way the program is structured. In this sample you can paste raw unformatted XML – Click XML Formatted will format the XML to a more readable format. You can also use the same option with JSON Files. Sample Database Zipped – https://anythingaccess.com/wp-content/uploads/2024/11/Pretty_XML.zip Code…
