Don’t Be Bound by a Sluggish System!

05.02.2023

Our client had a 15 year old program that uses Excel for the user interface and Access to store the data. The company is expanding and the program was running slow and running out the space. We migrated the data from Access to SQL Server. This effectively removes the size constraint and make the queries much faster.

It allows encrypting the social security numbers and it’s easier to deploy upgrades the code or file templates. To make maintenance easier, we used windows security, so as people come and go, the network admin just has to add or remove the user from a windows group.

Using Excel as a front end to a SQL Server database keeps training cost down as most users are familiar with Excel and we use our experience to ‘lock down’ the workbooks to keep data integrity. It also gives the users an easy way to get information for ad-hoc reports and presentations (i.e. Excel to PowerPoint), without having to come back to the developers for program modifications.

Our client now has a program that’s easier to change as their business needs change.

Where can we help you streamline those ‘bottleneck’ processes?

Recent News

Analyze PDF Files in Excel

In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his...

read more

Supporting your growing business

Here’s a situation we run into with our client. Someone builds a model in Excel and it works great. Time goes by and the business grows. That single workbook gets copied for the new customer/division/business unit. Quite a bit of manual work is needed to make it work...

read more

Will Excel go away?

I was recently asked whether Excel was going away. Now, I’m not a Microsoft mind reader but… here’s why I think Excel is here for a long while. Excel is too easy to use for it to go away. Most people can create a spreadsheet that reflects their business needs. That’s...

read more

Franklin Knows Best

For the want of an audited formula the report was inaccurate,For the want of an accurate report money was lost,For the want of money the company was lost,For the want of a company the jobs were lost,For the want of jobs the economy was lost,And all for the want of an...

read more