Hello all, a quick question:
How do we use VBA to overwrite SQL database table from excel?
I have seen previous discussion here on how to insert data from excel to SQL using VBA.
http://www.mrexcel.com/forum/excel-...plications-import-into-sql-server-2008-a.html
The key SQL command in that post is "INSERT INTO ... VALUE ..."
But for overwriting, what would be the correct SQL command expression? "UPDATE ... SET ... WHERE"? (assuming both the excel data range and the SQL table range are identical: same number of columns and rows)
Many thanks!!
How do we use VBA to overwrite SQL database table from excel?
I have seen previous discussion here on how to insert data from excel to SQL using VBA.
http://www.mrexcel.com/forum/excel-...plications-import-into-sql-server-2008-a.html
The key SQL command in that post is "INSERT INTO ... VALUE ..."
But for overwriting, what would be the correct SQL command expression? "UPDATE ... SET ... WHERE"? (assuming both the excel data range and the SQL table range are identical: same number of columns and rows)
Many thanks!!
