Em Andamento

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

Ver mais: 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, execute sql script, change access sql, script sql table, open table, script windows automate, studio 2010 access

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

ID do Projeto: #3057853

Premiar a:

GetReal

See private message.

$21.25 USD em 14 dias
(301 Avaliações)
7.2

12 freelancers estão ofertando em média $19 para este trabalho

weng0000

See private message.

$21.25 USD in 14 dias
(776 Comentários)
7.0
hwanghendra

See private message.

$21.25 USD in 14 dias
(453 Comentários)
6.9
finecodervw

See private message.

$21.25 USD in 14 dias
(152 Comentários)
6.3
ramsystemsvw

See private message.

$21.25 USD in 14 dias
(15 Comentários)
4.5
alekhine1962

See private message.

$21.25 USD in 14 dias
(19 Comentários)
4.2
code09

See private message.

$17 USD in 14 dias
(11 Comentários)
3.7
saifuddinme

See private message.

$17 USD in 14 dias
(12 Comentários)
3.0
kanhashriinc

See private message.

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

See private message.

$17 USD in 14 dias
(10 Comentários)
2.8
Athanas

See private message.

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

See private message.

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