Em Andamento

Execute SQL Query in Excel

Hello everybody,

This is an easy one, I need the following for an Excel spreadsheet VB macro that is able to :

1) Create a connection using ODBC to database

2) Create a connection using ADO to database

3) Execute any SELECT query against any table in the DB that can return multiple records

4) Parse through the result set and place the query values in the spreadsheet, one record per row, and however many columns the query returns (your example and my acceptance test will return dissimilar results)

4) Execute an INSERT query against same table

5) Execute an UPDATE query against same table

Please use "replaceable parameters" as much as possible, e.g.:

user_name = "username"

password = "password"

select_sql = "SELECT * from BLAH"

...

So that the code will use these variable values, and I can easily change the connection info, the query, etc.

Any questions? Just shoot me a note.

Tx,

George

## Deliverables

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

2) 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 before bid is awarded).

## Platform

Windows, Excel 97 to 2000

Habilidades: PHP

Ver mais: n query, my sql create database, vb in excel, visual basic form excel, vb excel, SQL Query, sql odbc, query table, macro e, excel to sql, excel to my sql, excel password, db query, excel database visual basic, form update excel, insert multiple records, sql multiple questions, insert macro excel, multiple excel, php connection select, insert variable, php select insert sql, visual basic database excel database, excel macro row, update code sql

Acerca do Empregador:
( 34 comentários ) United States

ID do Projeto: #2995730

Premiar a:

vba66avbv

See private message.

$25.5 USD em 10 dias
(52 Avaliações)
5.9

30 freelancers estão ofertando em média $58 para este trabalho

TakeRealUK

See private message.

$17 USD in 10 dias
(552 Comentários)
6.7
yenduttjain

See private message.

$8.5 USD in 10 dias
(117 Comentários)
6.7
techzonevw

See private message.

$63.75 USD in 10 dias
(156 Comentários)
5.8
realsoftwareltd

See private message.

$38.25 USD in 10 dias
(46 Comentários)
5.6
gabrielaizcorbe

See private message.

$25.5 USD in 10 dias
(13 Comentários)
4.7
preyasvw

See private message.

$34 USD in 10 dias
(34 Comentários)
4.4
vbdevvw

See private message.

$34 USD in 10 dias
(15 Comentários)
4.2
shabbirbhimani

See private message.

$12.75 USD in 10 dias
(33 Comentários)
4.2
shashikhanvw

See private message.

$212.5 USD in 10 dias
(15 Comentários)
3.8
odysseyvw

See private message.

$25.5 USD in 10 dias
(32 Comentários)
3.3
rolandanderson

See private message.

$42.5 USD in 10 dias
(5 Comentários)
3.2
genioussl

See private message.

$68 USD in 10 dias
(1 Comentário)
2.9
vw860431vw

See private message.

$68 USD in 10 dias
(10 Comentários)
2.8
stolevw

See private message.

$12.75 USD in 10 dias
(28 Comentários)
2.6
rjvbguru

See private message.

$59.5 USD in 10 dias
(5 Comentários)
1.8
doofusvw

See private message.

$21.25 USD in 10 dias
(1 Comentário)
0.2
normenvw

See private message.

$8.5 USD in 10 dias
(1 Comentário)
0.0
mohansrivw

See private message.

$74.8 USD in 10 dias
(0 Comentários)
0.0
ngains

See private message.

$85 USD in 10 dias
(2 Comentários)
0.0
truedeveloper

See private message.

$51 USD in 10 dias
(0 Comentários)
0.0