Updating tables in excel

Besides being time-consuming, you are likely to make mistakes.

So, what we do instead is to access the Access DB through VB and update all the values using ADO.

updating tables in excel-89updating tables in excel-9updating tables in excel-69updating tables in excel-59

A second consideration with SQL Server 2005 is that the Surface Area Configuration setting must be enabled to use this code in either case.

I have seen your previous tips (Export data from SQL Server to Excel and Different Options for Importing Data into SQL Server) related to working with Excel and SQL Server data.

The main command used in one of the tips is OPENROWSET.

What we need to do next is, for each product (row) in Excel, we need to update the corresponding price in the Access Database.

For that we need to filter the recordset based on the Product Name using: where s Product contains product name from each row in the Excel (one by one in a loop).

Leave a Reply