How To Use Excel To Create Large SQL Insert Statements

When adding records to a SQL database, data is often given in the format of an excel spreadsheet and it is up to the user to import the data into the database. It is impractical and time consuming to update an individual insert statement for each record. Instead, use excel as a resource to quickly and simply create a series of Insert statements which will also minimise human error.

» Article: Excel consultancy

How do you swap between continuous slides and the master slide throughout the presentation?

» Forum post: Powerpoint

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName
...

» Tip: Use VbNullString in VBA