Skip to main content

Dhanalakshmi Chandrasekar

Blogs from this Author

Connect/Compare Databases-Excel Macro

For comparing records between two tables in same database, or between two different Oracle databases, we may use the “MINUS” keyword in the query. But, if the databases under comparison are connected in different servers or any repositories, we can use simple Excel VBA script where the connection strings need to have the details of […]