ptpovo
asked on
Generate SQL script from Excel
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
Dim array_OfRemainingColumnsTh atActually ContainDat a
'' BEGIN OUTPUT FOR EACH ROW
UPDATE table
SET Column1=string_Column1, Column2=string_Column2
WHERE UniqueID IN (array_OfRemainingColumnsT hatActuall yContainDa ta)
GO
Move.Next
Dim string_Column1, string_Column2
Dim array_OfRemainingColumnsTh
'' BEGIN OUTPUT FOR EACH ROW
UPDATE table
SET Column1=string_Column1, Column2=string_Column2
WHERE UniqueID IN (array_OfRemainingColumnsT
GO
Move.Next
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi ptpovo,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept TimCottee's comment(s) as an answer.
ptpovo, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept TimCottee's comment(s) as an answer.
ptpovo, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
Comment from expert accepted as answer
Computer101
E-E Moderator
Computer101
E-E Moderator
ASKER