Transfer a SQL query to VBA code
$10-30 AUD
着払い
I have the following VBA code to delete data from an SQL database:
Dim strSQL As String
strSQL = "DELETE " & _
"FROM data_MonthlyBudget " & _
"WHERE TemplateSourceID = '" & Worksheets("CONFIG").Range("C16").Value & "' " & _
"AND BudgetVersionID = '" & Worksheets("CONFIG").Range("C15").Value & "'"
[login to view URL] strSQL
[login to view URL] strSQL
I need it adjusted to the following SQL query where BUDGETVERSIONNAME can be referenced to Worksheets("CONFIG").Range("C4") and TEMPLATESOURCENAME Worksheets("CONFIG").Range("C4"):
DELETE FROM dbo.data_MonthlyBudget
FROM dbo.data_MonthlyBudget mb
INNER JOIN dbo.source_Versions v on [login to view URL] = [login to view URL]
INNER JOIN dbo.source_TemplateSource ts on [login to view URL] = [login to view URL]
WHERE [login to view URL] = 'BUDGETVERSIONNAME'
AND [login to view URL] = 'TEMPLATESOURCENAME'
AND [login to view URL] = 'MonthlyBudget'
プロジェクトID: #16243514
プロジェクトについて
アワード:
I am an technical business analyst with 15 years professional experience building solutions with Excal, VBA, and SQL Server. I have built countless SQL scripts in VBA and would love to help you out!
5人のフリーランサーが、平均$34 で、この仕事に入札しています。
Hello. I have experience with both VBA and SQL. What is database you use? Microsoft Access? Thanks .
Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications I'm also available 24 x 7 Regard もっと