Where is my mistake ? (Macro to Update SQL From Excel)
Posted on 2009-02-13
I´m triying to UPDATE a SQL Table from Excel...
I´m calling a Stored Procedure from a VB Macro... I get connected but the results are not what I´m looking for.
I don´t know If the problem comes from the VB code I scrath from other web related post or from the procedure I get from a post on this web.
The Stored Procedure I´m calling from my SQL Server is:
/****** Object: StoredProcedure [dbo].[up_UpdateSpreadsheetData] Script Date: 02/13/2009 07:00:28 ******/
-- Create date:
What I got from the procedure is a column added in my spreadsheet (with the name of the db) to the left of the data that I want to update in the SQL Table and two more columns added to the right of the data. (one blank the other with the name of the DB).
If you can help me to determinate where if my mistake it will Help me A LOT to achieve what I´m looking for a very long time.
Thank you for reading untill this point and I´ll be eternally gratefull if you can help me to do what I need.