Verildi

Quick Excel VBA routine

I need a quick VBA routine written into a spreadsheet. Functionality as follows:

1. Read a certain column cell by cell downwards till the end of the data and copy all the values into a variable as a single string. (This is a SQL statement per screen shot)

2. Execute the SQL statement against an Oracle database (connection string to be hardcoded)

3. Put the resulting recordset, row by row, into sheet 1 from a predefined starting row.

I anticipate this is a quick 2hr task for someone who has the right skillset.

Beceriler: Veri Girişi, Veri İşleme, Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: vba excel 2016, vba excel download, useful vba codes for excel, vba excel functions, vba excel pdf, vba excel examples, excel vba programming pdf, vba excel 2013, excel vba and pivot table 2, excel vba and pivot table -- 2, excel vba xml file, excel vba cut paste cells, excel vba dashboard, excel vba macro paste adjacent column, simple excel vba

İşveren Hakkında:
( 0 değerlendirme ) Benfleet, Vietnam

Proje NO: #16718502

Bu iş için 1 freelancer ortalamada $20 teklif veriyor

watersev

Hired by the Employer

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(247 Değerlendirme)
6.4