Em Andamento

vb.net import to Oracle 10G from Excel

We are looking for seasoned VB.NET programmers that have at least 4 years OOP experience with Oracle and VB.NET.

The application we are building will consist of an Excel spreadsheet "Template" which will ultimately end up in the Oracle table.

## Deliverables

This entire process will execute through the use of an Oracle transaction.? Should the process fail, the entire insert will be rolled back.? No exceptions.? If any exception occurs, the process is rolled back.

There are likely to be 5,000? rows of data or about that in the insert (inside the excel spreadsheet.? Should row 5,000 fail, not one of the rows will be inserted in to the database.

You will select the information from the Excel spreadsheet (which will have a place on the ASPX to designate the path and filename) as "select * from sheet$1 in the form of a datatable.

Create a table in Oracle with 10 columns and a Spreadsheet "Template" with 10 columns which will contain dates, numbers and varchar datatypes which all correspond with the Oracle table created as having the same datatype.

Populate the spreadsheet template with a "header row" and give the spreadsheet 5,000 rows of dummy data.

This is the information the will inserted into the oracle table.

The oracle table will contain a first column as ID, which is NOT NULL as well as UNIQUE;? and in order to test the rollback feature, you will provide both an example with a successful 5,000 row insert as well as a 5,000 row insert that fails and rolls back on the 5,000th row due to a duplicate ID specified (i.e. 4999 as the ID)

Habilidades: ASP, PHP

Ver mais: excel import net oracle, vb net programmers, vb.net if, vb net feature, vb net 11, use of vb net, programmers numbers, programmers excel, oracle header, looking for duplicate data in excel, if vb net, example of vb.net, example of vb net, c++ for vb programmers, asp net programmers, application template excel, vb in excel, e vb, vb programmers, vb excel, oracle net, oracle data, net programmers, excel duplicate, database oracle

Acerca do Empregador:
( 27 comentários ) Harmony, United States

ID do Projeto: #3038871

Premiar a:

anandgothe

See private message.

$425 USD em 7 dias
(20 Avaliações)
4.3

7 freelancers estão ofertando em média $425 para este trabalho

pathos821vw

See private message.

$425 USD in 7 dias
(30 Comentários)
4.3
abhaysinghb

See private message.

$425 USD in 7 dias
(9 Comentários)
3.7
freisoftinc

See private message.

$425 USD in 7 dias
(5 Comentários)
3.3
khatripawan

See private message.

$425 USD in 7 dias
(5 Comentários)
2.4
durga2009

See private message.

$425 USD in 7 dias
(1 Comentário)
3.4
devcvw

See private message.

$425 USD in 7 dias
(0 Comentários)
0.0