Hey guys, new on the boards but have a question for you reguarding excel. I am looking to use excel to compare two databases and create a new database that has the differences listed in it. I also need a way to send emails too excel to create the first database.


Any tips or advice would be greatly appreciated.

Thanks,
J

what type of database will you be using SQL, Oracle, access text files?

are you looking to compare whole databases, or tables in databases, will the two databases have something in common, eg an id field

thinking about using SQL, but am open to suggestions. Here is the general break down:

The company im working for uses 6 supply houses(all of which use email invoices). Due to the fact that we buy in bulk we get markdowns over MSRP. We have an entire (8000 or so rows in excel) database which has calculated the price that we should recieve from each of our suppliers. What I would like to do, is to take the emails, have them compared to the price list that I already have, and then produce another sheet that has the differences between the two prices. The database that we have already (price list) uses the common item number from each supplier.

Let me know what you think...

From what you have written is seems as though you wan tto keep everything in Excel and not migrate to a database.

how does the data arrive from your suppliers, in a text file, a csv file, xml, html? do you envisage downloading data from these emails, or completely automating the whole process. You may also consider migrating the excel sheet of prices et al. (8000 rows of) to a more structured framework eg SQL database, you may be able to get away with access, depending on how much this list will grow. The process is still do-able in excel

If you have a common item number then it should be a fairly trivial process to actually construct the queries.

I was hoping for complete automation. The only problem with moving the database to SQL is that I would be the only person in the office who could do that.... and they want something that anyone can use.


Next question is how do I go about constructing the queries in excel?