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.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Benfleet, Vietnam

Nº du projet : #16718502

1 freelance fait une offre moyenne de $20 pour ce travail


Hired by the Employer

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(247 Commentaires)