Đang Thực Hiện

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)

Kỹ năng: Excel, Javascript, MySQL, Kiến trúc phần mềm, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 15 nhận xét ) Fitzroy, Australia

Mã Dự Án: #1010996

Đã trao cho:

rhomeu

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

$125 AUD trong 1 ngày
(17 Đánh Giá)
5.8

6 freelancer đang chào giá trung bình $143 cho công việc này

bharanisrihari

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

$150 AUD trong 2 ngày
(65 Đánh Giá)
6.5
allhen

Ready to work !!

$120 AUD trong 3 ngày
(52 Đánh Giá)
5.6
valleysoftware

I'm back. As previously discussed. Jim

$150 AUD trong 1 ngày
(29 Đánh Giá)
5.1
szhomestudio

I have changed my bid. Please check the PM.

$160 AUD trong 5 ngày
(1 Đánh Giá)
1.4
mb01a

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

$150 AUD trong 4 ngày
(0 Đánh Giá)
0.0