Generate SQL script from Excel
Posted on 2001-07-19
I'm comfortable with VBScript and ADO in ASP but have not worked with VBA in Excel. What I'd like to do is generate an SQL script from an Excel document. Each row in the document contains all of the parameters needed for each SQL statement.
Dim string_Column1, string_Column2
'' BEGIN OUTPUT FOR EACH ROW
SET Column1=string_Column1, Column2=string_Column2
WHERE UniqueID IN (array_OfRemainingColumnsThatActuallyContainData)