ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel.
Used to be executed to move data from Excel to SQL (or MySQL) database.
You need to run the macro while Excel table sheet is open, as always, can refer to workbook, sheet and startup cell in call.
Sheet should have table columns headers as 1st row (refer to attached screenshot).


Public

Tested

My Own Work

SQLTableName, Optional Shee = "Active", Optional Wb = "This", Optional StartCell = "A1"

Views 1 Downloads 0

VBA-Excel Database
ANmarAmdeen
875
Attachments
Revisions

v1.0