Annulé

VBA program to extract data from Excel ready for mysql

Hi,

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 : record data structure, vba with, uses data structure, spreadsheet javascript, simple data structure, set data structure, set data, need data structure, fun excel, data structure uses, data structure set, data structure problem, data structure example, best excel spreadsheets, best data structure, basic data structure, vba excel extract, vba for, uses excel, mysql data files, javascript data format, in vba, excel uses, customer data excel, a1

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

N° du projet : #1009965

47 freelance ont fait une offre moyenne de 282 $ pour ce travail

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

300 $ AUD en 3 jours
(165 Commentaires)
6.9
srinichal

let us discuss further

300 $ AUD en 5 jours
(86 Commentaires)
6.8
ineedWorkJob

sir plz check pm !

250 $ AUD en 3 jours
(150 Commentaires)
6.5
svet63

VBA developer since 1997. Can do. Regards, Svet.

350 $ AUD en 3 jours
(69 Commentaires)
6.5
bharanisrihari

Hi, I'm an excel VBA expert. Please check PM for details. Thanks!

250 $ AUD en 2 jours
(65 Commentaires)
6.5
aruhat

Hello Please see PM. Regards, Chandni

950 $ AUD en 7 jours
(10 Commentaires)
6.1
koolsidz

Please PMB

250 $ AUD en 0 jours
(107 Commentaires)
5.8
rhomeu

Please check PM I have included working demo and the demo is almost complete.

250 $ AUD en 1 jour
(17 Commentaires)
5.8
fedalal2

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

300 $ AUD en 3 jours
(34 Commentaires)
5.7
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

250 $ AUD en 1 jour
(39 Commentaires)
5.4
vbexcel

Excel/VBA expert - ten years experience.

250 $ AUD en 3 jours
(27 Commentaires)
5.3
Lotusdeveloper

Please refer the PMB for more details

260 $ AUD en 5 jours
(79 Commentaires)
5.2
morpheeen

Hi, I can help you with this if you like. I'm experienced in excel data extracting.

250 $ AUD en 5 jours
(39 Commentaires)
5.2
mike25

Please check your Inbox, Regards, Mike

250 $ AUD en 2 jours
(33 Commentaires)
5.1
torajiv

Detailed offer in PM - Many thanks and regards

250 $ AUD en 5 jours
(41 Commentaires)
5.1
djain01

Lets do it... Also pls check the PMB for more details and the questions. Thanks djain

250 $ AUD en 2 jours
(29 Commentaires)
5.0
kakoappa

Hello. Please check your PMB.

250 $ AUD en 1 jour
(12 Commentaires)
5.0
valleysoftware

I can macro your way out of this one! See PMB.

250 $ AUD en 1 jour
(25 Commentaires)
5.0
tamrakar81

Hi, Please check PM . Thanks, T

250 $ AUD en 0 jours
(25 Commentaires)
4.8
telemarketing555

Hello. Please check your PM. Thank you.

250 $ AUD en 1 jour
(26 Commentaires)
4.4