Database Integration

Here is an example of integrating Excel with an external database and custom forms. Using a database has many advantages. Databases are great for handling large and interconnected sets of data. They also allow multiple people to use and update the data at the same time. In these kinds of projects, Excel basically becomes the front end software that interfaces with the database and allows for interaction – viewing and changing the data.
In this example, the system tracks over 20,000 parts for an eRetailer. They often have 4 or 5 people connected to the system at the same time. To get the latest data, they simply have to Refresh their sheets and continue working. This system was originally built without a database. As the company grew, it became clear that a more robust solution was needed and the database was added.
We also added custom user forms (windows) that open up to display specific data and to allow for easy data entry. The forms are also used to validate data entry, making sure that the correct data is captured and stored in the system.
This system also manages over 100,000 part photos. As photos are added to the system, the photos are automatically renamed and moved to an organized location. When a part is ready to be listed, the photos are automatically uploaded to servers so that the photos can be shown in eCommerce listings.
See a video demonstration of loading data from a database here.