SQL Connector for MS Excel

PublishedAugust 13, 2010

•1 min read

Pieter van der Westhuizen, a professional freelance web & mobile developer and founder of Coalition Software.

Ever wished you could update your SQL data directly from within MS Excel? It would be so quick and easy right, I mean you could just drag data, build your own formulas and calculations.

Also, wouldn’t it be great if you could have random test data to go with it? Well folks, I’m proud to announce the imminent release of my SQL Connector for MS Excel product.

Using this utility you can edit, generate and update your SQL server data easily and quickly without leaving MS Excel. I’ve uploaded a short video to YouTube to illustrate the basic functionality.

Keep watching this space for more news!

More from this blog

A Study in Flutter: Dynamic Forms

A recent requirement came up for configurable dynamic forms in a mobile application. There are a few dynamic form packages for Flutter, but I wanted a bit more control over the schema and behavior of the form. Here follows my attempt at creating dyna...

Jul 25, 20237 min read

Introduction to CSharp2Dart.com

If you've ever written a mobile app with Flutter that integrates with an API, then you'll know that there are a lot of model objects that get passed between the app and the API. JSON Serialization in Flutter can also take a fair amount of boilerplate...

Jan 7, 20223 min read

Searching Azure Blob Storage using Blob Index

Back in May 2020, Microsoft announced a new feature for Azure Blob Storage called Blob Index. Essentially, this enables you to add key/value tags to your Blob objects and be able to query said Blob objects without having to use a separate service lik...

Apr 19, 20215 min read

Searching Azure Blob Storage using Blob Index

Using AWS Cognito with Vue/NuxtJS

In my last post, "Using AWS Cognito with Xamarin Forms", I showed how to authenticate with Amazon Cognito using Xamarin Forms and the Xamarin.Essentials Web Authenticator. In this post, we'll go through the process of using the AWS Cognito Hosted UI ...

Apr 6, 20216 min read

Using AWS Cognito with Xamarin Forms

In this post, I'll show you how to quickly and easily set up user authentication for your Xamarin Forms app using Amazon Cognito. AWS Cognito is a user identity management solution by Amazon. It is a really easy way to add authentication to your appl...

Mar 24, 20217 min read

Mythical Man Moth

80 posts

Hi, I’m Pieter van der Westhuizen. I'm a professional freelance web & mobile developer from South Africa that has been code slinging for more than 23 years. https://youtube.com/shorts/aCCKAnDNrzM

Command Palette

More from this blog