Sharing Microsoft Excel Data Using SQL Server or Microsoft Access

Summary Demonstrate how data can be cleaned up and shared across multiple users while allowing reports and visualization in well-known and common tools. Technologies Microsoft SQL Server (Express) Microsoft Access & The Access Runtime Microsoft Excel Add-on: Microsoft Power BI The need Provide a data aggregation and cleanup tool with customized and shared Excel reports. […]

Continue reading

Listing Excel Workbooks and Sheets from Microsoft Access using VBA

SUMMARY: Tutorial to show how to use Microsoft Access VBA to retrieve and display open Workbooks and their Worksheets. I create a lot of dashboards, reporting systems, and document automation projects built extensively using Visual-Basic for Applications. Often, the infrastructure looks like: Microsoft Access as a front-end application. SQL Server as the back-end data repository. […]

Continue reading

Business Automation

Workflow automation solutions. Document assembly (contracts, reports, proposal systems, letters, emails) – all driven by your data. We’ve built solutions for insurance, legal, manufacturing, and entertainment.

Continue reading
Default Facebook Sharing Image for Wordpress using Google Drawings

How to Create a Default Website Image for Facebook Sharing Using Google Drawings

Whew!!! Long title. I published a simple tutorial on how to create the image below with the text overlay and semi-transparent background. Google Drawings is a FREE app that comes as part of your Gmail address or with your GSuite subscription. Benefits FREE! Cloud-based: any computer, any location, no software to install Allows collaboration: Team […]

Continue reading
Los Angeles based Excel and Access VBA Programming

Using Excel VBA to Automate SQL Server Data Migration

Data Migration Sucess Some simple concepts to help you with more successful conversion and migration projects. Front-load the Automation Automation requires more work at the start – on the front-end of a project. Create simple data connection and output tools immediately. Doing so will give your team the confidence to defer to the automation tool […]

Continue reading