Usage data being sent back
I'm leaving my current company at the end of the month and there are many things that need tying up. One of these is how I get a load of raw data in Excel and import it into Sql Server. The task is extremely difficult to automate because of the crazy manner in which the data comes. The open nature of a spreadsheet means that it comes completely different each time we get it resulting in lots of messing about and vlookup pain to get it into a nice importable format.?