Concluído

VB Script to automate running a sql script and MS Access table manipulation

I need a VB script that will do the following in order from my Windows XP Workstation. I also need everything in the script well documented in case I need to change settings later on. I would like it written in VB 6 and NOT .net.

1. Open and execute a simple sql query I have created on a MS SQL db.. I have MS SQL Studio 2005 on my workstation.

2. Open a MS Access db file I have created with two tables. I have Access 2003 on the workstation.

3. Delete all records in one table (Previous weeks data).

4. Copy all records from second table (Current Week data) to the

previous week table.

5. Delete all records current week table.

6. Copy results from sql query in step 1 into the Current Week table.

7. Close all applications when finished.

*The sql query and Access db file will be in the same folder.

Basically what I am doing is keep on ongoing record of current and week old data for comparisons. I only need the current and previous week data for this task. This script /task will be run once a week (Mondays) for my purposes.

## Deliverables

Once the bid has been accepted I can provide the sql script and the access db for development and testing.

Habilidades: PHP

Veja mais: ms access with php, what is ms sql, what is ms access, ms visual studio, ms access sql, ms access 2010, vb 6, sql script , SQL Query, file manipulation visual studio, keep record access, access delete, sql created, php script execute, net sql script, access query table, visual basic delete access, script automate, script run access sql, access table query, access testing, simple task script, access sql query, sql query access, delete sql php

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

ID do Projeto: #3057853

Concedido a:

GetReal

See private message.

$21.25 USD em 14 dias
(497 Comentários)
7.6

11 freelancers estão ofertando em média $19 para esse trabalho

hwanghendra

See private message.

$21.25 USD in 14 dias
(381 Comentários)
7.3
weng0000

See private message.

$21.25 USD in 14 dias
(680 Comentários)
6.7
finecodervw

See private message.

$21.25 USD in 14 dias
(128 Comentários)
5.9
ramsystemsvw

See private message.

$21.25 USD in 14 dias
(8 Comentários)
3.7
alekhine1962

See private message.

$21.25 USD in 14 dias
(16 Comentários)
3.9
saifuddinme

See private message.

$17 USD in 14 dias
(11 Comentários)
2.9
alpinesoftw

See private message.

$17 USD in 14 dias
(11 Comentários)
2.8
kanhashriinc

See private message.

$21.25 USD in 14 dias
(9 Comentários)
2.9
RedSpyder

See private message.

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

See private message.

$8.5 USD in 14 dias
(2 Comentários)
0.2