I'm attempting to reconcile data from the website along with a database programmatically. At this time my process is manual. I download data in the website, download data from the database, and reconcile utilizing an Stand out
vlookup. Within Stand out, I'm only repairing 1 date for a lot of products.
Let me programmatically reconcile the information for multiple dates and multiple products. However , I must download the information in the website by hand. I have come across people doing "outer joins" and "table joins" but I don't know where to start. Is something which I code in VBA or notepad?
Generally I actually do this by bulk placing the web site data right into a staging table after which write choose statments to become listed on that table to my data within the database. You may want to do cleanup first to have the ability to match the records if they're saved in a different way.
Python is really a scripting language. http://www.python.org
You will find tools to let you read Stand out excel spreadsheets. For instance:
You may also use Python to speak to your database server.
Most likely the simplest method to automate this really is in order to save the stand out files you're able to disk, and employ Python to see them, evaluating that data using what is within your database.
This won't be a trivial project, but it's very flexible and easy. Trying to get it done all in SQL is going to be, IMHO, a recipe for frustration, particularly if you are a new comer to SQL.
You might do that by utilizing VBA to see inside your stand out files and generate SQL Place claims which are suitable for your DB schema. Then use SQL to check them.