Unanswered: SQL UPDATE Query from within Excel 2002
Hi all, I'm new to VBA coding (especially for Excel) and was wondering if anyone knows how I might perform a SQL UPDATE Query from within an Excel worksheet? I have the worksheet setup to query from a MS SQL Server db (via ODBC) and populate the spreadsheet. I would *LOVE* the capability of editing particular cells and then performing a macro command to export the data back, updating the original database. I can do it manually via MS-Query because all data comes from a single table, but I would really like to automate the process. If anyone could point me in a direction to get me started, I'd be grateful. Thanks-
That did the trick!!! THANK YOU THANK YOU THANK YOU!! It worked like a charm! I had an idea of what the logic would be like, but I didn't understand quite how to get there. ADO works great! Thank you so much.