Доручено

Access Database Repair

*Wanted:*

Small freelancer job in MS Access with MS SQL ’08 and VB Script.

We have an MS Access 2010 database (connected to an MSSQL ’08 server) that, upon click of a button, copies names & addresses and such from a set-aside processing table to its more permanent home [url removed, login to view] MySQL, we can partially avoid duplicate record creation brought on by this record copying using the REPLACE INTO syntax, but not in this version of [url removed, login to view] need a procedure that gets us to the same place, i.e., for any records which are already in the target table, UPDATE, otherwise INSERT, based on matching a given key. We're sick of inserting blind and scanning for duplicates afterwards!

We will not be able to provide direct access to the DB in question but can provide the record copying SQL statement and surrounding VB script on the button.

*Expected Output:*

·Any new VBScript and/or SQL commands that implement the requested action OR a completed example from your own Access creation

·If any new tables are required to complete the procedure, we will need the SQL definitions of said tables (of course).

Навички: PHP, Архітектура ПЗ, Тестування ПЗ

Показати більше: vb creation, procedure for freelancer, ms sql server freelancer, mssql freelancer, ms access with php, ms access database freelancer job, job ms access, freelancer vbscript, freelancer statement, freelancer sql database, freelancer server update, freelancer server software, freelancer insert, freelancer for permanent job, freelancer access job, db freelancer, database in freelancer, access database software, ms access sql, database creation software, ms access job, ms access 2010, freelancer procedure, freelancer architecture job, sql duplicates

Про роботодавця:
( 1 відгук ) Topeka, United States

ID проекту: #4311195

8 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $28/год.

illuminesoft

We have developed complex VBA scripts, SQL Server stored procedure/functions and code to generate unique IDs etc. We have over 13 years experience developing simple/advanced MS Access database projects.

$15 USD / год.
(320 відгуків(-и))
7.4
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$50 USD / год.
(348 відгуків(-и))
6.9
oobretenov

I have experience in Access and Sql.

$16 USD / год.
(2 відгуків(-и))
1.9
edericogrocha

I have read your requirements. Part of my career for a while (2 years more or less) was to do reporting work, using msaccess and sql server, and lots of vba. I think I can help you with this.

$25 USD / год.
(3 відгуків(-и))
1.8
srdas2012

We are Expert in Access ,Sql & Vb Script we can do your Job,

$15 USD / год.
(2 відгуків(-и))
1.6
post3122

I have more than 15 years of experience with MS Access (all versions), MS SQL Server (versions 6.5 trough 2012) (including SSRS, SSAS and SSIS (earlier versions DTS)).

$50 USD / год.
(0 відгуків(-и))
0.0
ChrisAU76

Your required functionality is similar to previous work that I have undertaken. Depending on the level of detail that you are able to provide, I am happy to cap my estimate at 10 hours to ensure you have peace of mi Більше

$25 USD / год.
(0 відгуків(-и))
0.0
FreelancerLLC

I have expertise in MS Access, SQL and VB Script. Quality work assured!!

$25 USD / год.
(0 відгуків(-и))
0.0