В роботі

CSV file import to access mdb

Automated CSV file import to Access Mdb

**1**. Locate file in directory (Option to set directory location in program)

**2**. Process file appending all records where sales type = 1 to a table called tblDailySales (Option to specify database and location of database). All field names in MDB to be the sames as the csv file.

following fields need to be modified at import.

**Date** in dd/mm/yyyy format

**Item number**, all 14 digit numbers to have the leading digit stripped leaving a 13 digit number

eg: 12345678901234 becomes

2345678901234

**Qty 1, Qty 2 and Qty 3** require the 3 trailing zeros to be stripped

eg: 3000 becomes 3

**3.** Move processed file to another directory (option to set location)

**4.** Record a log to notify if import was successfull or failed.

**5.** Schedule option, to set proccess to a certain time of day (file will be processed daily), optional manual running of import procedure.

CSV file is attached as is [url removed, login to view] database

Thank You

Brad

## Deliverables

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

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP, Windows 2000 windows 98.

Written in visual basic 6

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

Показати більше: csv mdb access, dd for hire, dd 4 hire, daily access, import csv mdb file, mdb, in process access, csv file, brad, appending, php process csv, mdb csv code, import access database php, mdb import, csv form, file type software, php table csv, table csv, code import csv access, access database process, sales access, csv table, visual schedule, access form record, import database access php

Про роботодавця:
( 0 відгуки(-ів) ) Australia

ID проекту: #3304112

Доручено:

rubesvw

See private message.

$34 USD за 21 дні(-в)
(13 відгуків(-и))
4.1

34 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $51

techxpertAsh

See private message.

$42.5 USD за 21 дні(-в)
(639 відгуків(-и))
7.8
softservicesvw

See private message.

$85 USD за 21 дні(-в)
(330 відгуків(-и))
7.6
icodeinvb

See private message.

$42.5 USD за 21 дні(-в)
(314 відгуків(-и))
7.1
tristone

See private message.

$85 USD за 21 дні(-в)
(73 відгуків(-и))
6.9
emadomarvw

See private message.

$59.5 USD за 21 дні(-в)
(65 відгуків(-и))
6.8
brsofts

See private message.

$21.25 USD за 21 дні(-в)
(274 відгуків(-и))
6.6
silkroutesl

See private message.

$43.78 USD за 21 дні(-в)
(126 відгуків(-и))
6.6
barcasoft

See private message.

$34 USD за 21 дні(-в)
(39 відгуків(-и))
5.9
alinfaur

See private message.

$63.75 USD за 21 дні(-в)
(158 відгуків(-и))
5.8
gopikap

See private message.

$42.5 USD за 21 дні(-в)
(54 відгуків(-и))
5.1
dacaposolutions

See private message.

$29.75 USD за 21 дні(-в)
(46 відгуків(-и))
4.8
vw594130vw

See private message.

$25.5 USD за 21 дні(-в)
(65 відгуків(-и))
4.3
denasvw

See private message.

$29.75 USD за 21 дні(-в)
(83 відгуків(-и))
4.3
brantk

See private message.

$11.9 USD за 21 дні(-в)
(35 відгуків(-и))
4.2
blexvw

See private message.

$42.5 USD за 21 дні(-в)
(17 відгуків(-и))
3.9
DenBorg

See private message.

$55.25 USD за 21 дні(-в)
(4 відгуків(-и))
2.4
jensoftware

See private message.

$21.25 USD за 21 дні(-в)
(2 відгуків(-и))
2.0
enzo10

See private message.

$51 USD за 21 дні(-в)
(1 відгук)
0.8
chsr

See private message.

$42.5 USD за 21 дні(-в)
(1 відгук)
0.8
naylun

See private message.

$15.3 USD за 21 дні(-в)
(1 відгук)
0.5