Đã Hủy

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)

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

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

Xem thêm: 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, fun with excel, excel vba db, data structure uses, data structure that, data structure set, data structure problem

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

Mã Dự Án: #1009965

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

schandraram

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

$300 AUD trong 3 ngày
(165 Đánh Giá)
6.9
srinichal

let us discuss further

$300 AUD trong 5 ngày
(86 Đánh Giá)
6.8
ineedWorkJob

sir plz check pm !

$250 AUD trong 3 ngày
(150 Đánh Giá)
6.5
svet63

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

$350 AUD trong 3 ngày
(69 Đánh Giá)
6.5
bharanisrihari

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

$250 AUD trong 2 ngày
(65 Đánh Giá)
6.5
aruhat

Hello Please see PM. Regards, Chandni

$950 AUD trong 7 ngày
(10 Đánh Giá)
6.1
koolsidz

Please PMB

$250 AUD trong 0 ngày
(107 Đánh Giá)
5.8
rhomeu

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

$250 AUD trong 1 ngày
(17 Đánh Giá)
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 trong 3 ngày
(34 Đánh Giá)
5.7
nagybatonyi

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

$250 AUD trong 1 ngày
(39 Đánh Giá)
5.4
vbexcel

Excel/VBA expert - ten years experience.

$250 AUD trong 3 ngày
(27 Đánh Giá)
5.3
Lotusdeveloper

Please refer the PMB for more details

$260 AUD trong 5 ngày
(79 Đánh Giá)
5.2
morpheeen

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

$250 AUD trong 5 ngày
(39 Đánh Giá)
5.2
mike25

Please check your Inbox, Regards, Mike

$250 AUD trong 2 ngày
(33 Đánh Giá)
5.1
torajiv

Detailed offer in PM - Many thanks and regards

$250 AUD trong 5 ngày
(41 Đánh Giá)
5.1
djain01

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

$250 AUD trong 2 ngày
(29 Đánh Giá)
5.0
kakoappa

Hello. Please check your PMB.

$250 AUD trong 1 ngày
(12 Đánh Giá)
5.0
valleysoftware

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

$250 AUD trong 1 ngày
(25 Đánh Giá)
5.0
tamrakar81

Hi, Please check PM . Thanks, T

$250 AUD trong 0 ngày
(25 Đánh Giá)
4.8
telemarketing555

Hello. Please check your PM. Thank you.

$250 AUD trong 1 ngày
(26 Đánh Giá)
4.4