You are currently browsing the archives for posts tagged as VBA.

VBA + MySQL: Checking For Duplicate Key Before Data Insertion

This article has been long overdue; so I apologize to newbie who orignally asked how to do duplicate key checking before inserting Excel data into a MySQL database.

I got a few minutes of free time today, so I decided to draft a sample workbook that will demonstrate this process. You can download the sample workbook here. Standard disclaimer: This file has been found to be virus-free when uploaded. However, you are highly recommended to scan the file again with an up to date anti-virus software before opening it.

Read the rest of VBA + MySQL: Checking For Duplicate Key Before Data Insertion »

Inserting An Unknown Number Of Excel Rows Into MySQL With VBA

I’ve been asked how to insert an unknown number of lines of data from an Excel spreadsheet into MySQL. I thought that rather than answer that question in a comment reply, I might as well create a sample Excel spreadsheet with the solution already in place.

Of course, I will explain the rationale behind my method in this article first 🙂

Read the rest of Inserting An Unknown Number Of Excel Rows Into MySQL With VBA »