Sorry this had been cancelled and reposted due to the incorrect budget being set on the first project.
I have the fun task of getting data which has been entered into Ms Excel spreadsheets over the past 5 years into a mySQL database.
The client uses excel spreadsheets to record customer body measurements as part of a personal training service. There are over 20 spreadsheet files, each with at least 50 sheets of data. The problem is the data is not set in a database friendly format. (see example attachment)
I got the client to enter to the userid into cell 'A1' on each spreadsheet. I need to get this data either onto another excel spreadsheet or into a CSV file ready to import. I'm thinking the best way to do this would be to create a VBA program that grabs data from certain cells and places them sequentially onto database ready lines.
The DB structure for the mysql DB will be (tbl_measurements):
So, what I need is a simple VBA program (or similar), that reads in a single excel file, loops though all cells on each sheet, and spits out either a excel file, or CSV file in the correct format. (i.e. ready to import into a mySQL database)