En cours

VBA program to extract Excel data ready for mysql (Repost)

Hi,

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):

user_id INT(10)

mm_date DATETIME

mm_weight DOUBLE

mm_abdominal DOUBLE

mm_subscapula DOUBLE

mm_bicep DOUBLE

mm_tricep DOUBLE

mm_sum_of_4 DOUBLE

mm_diff_mm DOUBLE

mm_diff_per DOUBLE

mm_history DOUBLE

mm_shoulders DOUBLE

mm_chest_in DOUBLE

mm_chest_ex DOUBLE

mm_bicep_right_un DOUBLE

mm_bicep_right_flex DOUBLE

mm_bicep_left_un DOUBLE

mm_bicep_left_flex DOUBLE

mm_waist DOUBLE

mm_navel DOUBLE

mm_hips DOUBLE

mm_quad_right DOUBLE

mm_quad_left DOUBLE

mm_calve_right DOUBLE

mm_calve_left DOUBLE

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)

Compétences : Excel, Javascript, MySQL, Architecture Logicielle, Visual Basic

Voir plus : vba mysql excel extract data, what is record in data structure, what is data structure in c, what is data structure, what is data in data structure, what is a data structure in c, what is a data structure, what data structure, what are data structure, vba with, uses of data structure, to do fun, spreadsheet javascript, spreadsheet in javascript, simple data structure, set in data structure, set data structure, set data, need of data structure, m format in excel, import ms project, fun with excel, excel vba db, data structure uses, data structure that

Concernant l'employeur :
( 15 commentaires ) Fitzroy, Australia

N° du projet : #1010996

Décerné à :

rhomeu

Hi, This is the same user that sent you a good demo. Please check PM. Thank you!

125 $ AUD en 1 jour
(17 Commentaires)
5.8

6 freelance ont fait une offre moyenne de 143 $ pour ce travail

bharanisrihari

Hi, Excel VBA expert here. Please check PM for details. Thanks!

150 $ AUD en 2 jours
(65 Commentaires)
6.5
allhen

Ready to work !!

120 $ AUD en 3 jours
(52 Commentaires)
5.6
valleysoftware

I'm back. As previously discussed. Jim

150 $ AUD en 1 jour
(29 Commentaires)
5.1
szhomestudio

I have changed my bid. Please check the PM.

160 $ AUD en 5 jours
(1 Commentaire)
1.4
mb01a

I've done similar several times. I can do it again if you want me to ..

150 $ AUD en 4 jours
(0 Commentaires)
0.0