Access database update script.

Cancelado Publicado Jun 12, 2007 Pagado a la entrega
Cancelado Pagado a la entrega

I need an script, written in WSH that can synchronize certain fields in between 2 different access databases, and write fields that can't be matched to a CSV file.

Form/setting:

[Search field]

[Update field]

[Update field min. length]

[Target database]

[Source database]

[Override is existing (boolean)]

[Matching regular expressions]

E.g.

Database 1 (100,000 records):

Fields: seqno, address, name, url, email, description.

Database 2 (5,000 records):

Fields: url, email.

Search field: url

Update field: email

Update field min. length: 10

Target database: database 1

Source database: database 2

Override if existing: yes

1. Start with record 1 in database 2.

2. Check if length of email field in database 2 is at least 10. If less than 10, skip to next record.

3. Search database 1 for record where url matches url in database 2. Update email field of database 1 with email field in database 2 for that record.

4. If data exists in field email in database 1, override.

Notes:

1. Matching should allow for regular expressions (setting). The default regular expression should ignore space, e.g. if source field url="[login to view URL] ", then it should match with update field url="http://www.abc.com".

2. Records in database 2 that has no matches in database 1 should be written to a CSV file.

3. Test databases will be provided on award of job.

ASP Programación en C Procesamiento de datos JavaScript Windows Desktop

Nº del proyecto: #151831

Sobre el proyecto

7 propuestas Proyecto remoto Activo Jun 14, 2007

7 freelancers están ofertando un promedio de $76 por este trabajo

yousefla

Hi, Sent you more info in the PM Regards,

$90 USD en 2 días
(58 comentarios)
7.1
lavr

See private message.

$60 USD en 3 días
(44 comentarios)
5.7
dpspecialist

Will do it in MS Access...

$65 USD en 3 días
(1 comentario)
2.4
ATSol

Pls see PMB

$70 USD en 2 días
(0 comentarios)
0.0
kaddubetu

I will do this in Java and MS Access or whatever Databse you offer MYSQL,DB2,Oracle. I can provide you Text Base interface or Simple GUI in swings or can be Property file configurable

$50 USD en 3 días
(0 comentarios)
0.0
prakos

Provide you a WSH solution. Settings are stored in a text configuration file.

$100 USD en 4 días
(0 comentarios)
0.0
mehveen

I have just finished the other 2 projects that were on hand and now ready to start this one in MS access. I can do the job in 1 day. Looking forward to work with u.

$100 USD en 1 día
(0 comentarios)
0.0