Em Andamento

Load Excel file

I have 3 (three) excel files with a fixed format, and every row have 8 columns. 4 columns are data to locate in a database in SQL Server (key fields). The other 4 columns contains data to insert or update in the same database. Each row can generate more than 1 (one) record on a table and can affect 3 or 4 tables in the database. Additionally, you must detect if the key fields data exists on the database and if so, update the database. if not, write a log file. The data access is made with ADO and the code must be Visual Basic 6.0 in only one form. The excel files can be located by browsing, and if the format doesn´t comply with especification, must be messaged to the user.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Windows 98/XP, Visual Basic 6.0, SQL Server 7.0 or higher

Habilidades: PHP

Ver mais: visual basic form excel, excel visual basic, code columns excel access, excel log database, excel database visual basic, server load log, form update excel, excel contains, update sql file, excel access table, php load data, load excel, generate code database record, sql server access excel, php load table, log excel visual basic, excel record, update insert sql, excel file columns, load doesn, excel form access, write file excel, record excel, php excel file generate, php table excel

Acerca do Empregador:
( 5 comentários ) Mexico

ID do Projeto: #3003343

Premiar a:

rinatsalikhov

See private message.

$17 USD em 14 dias
(13 Avaliações)
4.5

29 freelancers estão ofertando em média $55 para este trabalho

theangrycoder

See private message.

$59.5 USD in 14 dias
(61 Comentários)
5.9
algorithmltd

See private message.

$76.5 USD in 14 dias
(15 Comentários)
5.4
masterbrains

See private message.

$76.5 USD in 14 dias
(21 Comentários)
5.4
sreeyavw

See private message.

$63.75 USD in 14 dias
(31 Comentários)
5.1
gopikap

See private message.

$21.25 USD in 14 dias
(54 Comentários)
5.1
TechyDesigns

See private message.

$83.3 USD in 14 dias
(26 Comentários)
4.8
vw959599vw

See private message.

$42.5 USD in 14 dias
(14 Comentários)
4.8
cristipvw

See private message.

$25.5 USD in 14 dias
(20 Comentários)
4.1
tlbell69

See private message.

$76.5 USD in 14 dias
(18 Comentários)
4.1
jspsenthilvw

See private message.

$17 USD in 14 dias
(22 Comentários)
3.9
barreiro04

See private message.

$51 USD in 14 dias
(22 Comentários)
3.7
mysticsvw

See private message.

$59.5 USD in 14 dias
(3 Comentários)
3.5
themylab

See private message.

$68 USD in 14 dias
(9 Comentários)
3.3
bigursusvw

See private message.

$34 USD in 14 dias
(12 Comentários)
2.9
deryldsa

See private message.

$8.08 USD in 14 dias
(17 Comentários)
2.9
vatakasi

See private message.

$42.5 USD in 14 dias
(5 Comentários)
1.8
rjvbguru

See private message.

$42.5 USD in 14 dias
(5 Comentários)
1.8
jvmvw

See private message.

$21.25 USD in 14 dias
(3 Comentários)
1.3
andyhk95

See private message.

$68 USD in 14 dias
(1 Comentário)
1.1
jaysinha

See private message.

$127.5 USD in 14 dias
(0 Comentários)
0.0