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)
Sorry forgot to change the drop list on the budget. My budget for this is not 250-750!
My budget is more like 80 to 160 AUD
47 freelance ont fait une offre moyenne de 282 $ pour ce travail
Hi, I have more 10 years experience in MS Excel and MS Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex