In Progress

VBA MSAccess - CSV File

Hello

I need to create a csv file and upload it to a ftp server.

Only VBA / MsAccess. I will run this with a macro (code must be open, I may edit it). I don't need a form.

...

You will have 3 tables (I provide them).

"Table 1" - I fill it with 8 fields. Read sampleID and sample status. Also you will look at "date" and just process only when (date<=now()-20) or (date= null).

"Table 2" - after running your script, you will fill or update this table. It is a copy of table 1. You will fill also the date that status has changed (this is the day you process it). Update sample that have changed or new samples.

"Table 3" - fill here the records you will upload

Steps:

1- read table 1, compare it with sampleid and status in table 2

2- if there are new records in table1 or status has changed, then fill table3. You will fill "table 3" with new records, records that change in this process and records that have changed in the last 10 days (remember that you fill the date in table2).

3- create a csv file with the records in "table3". I will provide one example.

4- upload the csv file to a ftp server

5- you will fill also a registry that will contain date/hour start/finish.

6- update "table2"

Scrow payment

Thanks

Skills: Microsoft Access, Visual Basic

See more: create csv vba msaccess, vba open csv file, msaccess vba csv, vba with, open csv file msaccess macro, msaccess vba create table, update csv vba, msaccess csv, microsoft vba, microsoft macro, in vba, vba, vba compare, open file, null, microsoft access vba, Macro vba, macro to upload, csv, csv file, ACCESS VBA, csv script vba, vba open access, update status code, edit macro

About the Employer:
( 67 reviews ) Silla, Spain

Project ID: #664585

Awarded to:

KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$40 USD in 2 days
(30 Reviews)
4.8

25 freelancers are bidding on average $112 for this job

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$150 USD in 3 days
(114 Reviews)
6.6
tootwotrue

Hello. Please see PMB for details. Drew

$120 USD in 2 days
(9 Reviews)
5.6
Wonderer

Hi, Can do this perfectly. Thanks, Al

$116 USD in 3 days
(42 Reviews)
5.5
srinichal

I can deliver the code in VBA

$180 USD in 3 days
(27 Reviews)
5.3
MAnkita

Hello,Please refer your [url removed, login to view] you.

$200 USD in 7 days
(35 Reviews)
5.2
djucuti

Hello, Please see PM

$125 USD in 5 days
(26 Reviews)
4.9
SmartGuru

Hello, I have read your requirements and I can provide you a solution in Ms access 2003 / MS Access 2007. Please check PMB. Kind regards.

$40 USD in 3 days
(11 Reviews)
4.3
BrindabanB

Hi, I can do this in one day. I am good with VBA, VB & VB.NET. My customers has given me a good review, my prices are equally competent. Hope I fit to do your project. Looking forward to your reply. Regards More

$40 USD in 1 day
(6 Reviews)
4.2
oFAZo

Exceptional quality & Quick work. Please refer to PMB for details, Profile & Reviews for quality of work. Thanks FAZ

$125 USD in 1 day
(13 Reviews)
4.1
piyushdpatel

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$150 USD in 2 days
(10 Reviews)
4.1
syslogic

please see the PMB.

$160 USD in 5 days
(3 Reviews)
3.9
freddyho

Please see your PMB

$120 USD in 3 days
(7 Reviews)
3.8
ivancp

Please read the PM

$120 USD in 4 days
(6 Reviews)
3.7
skujuira

Dear Mr./Ms., Canada based and Microsoft certified professional. Quality work. Please refer your PMB. Regards

$200 USD in 6 days
(5 Reviews)
3.6
shafi7136

hi, i express my interest to work with you. thanks, shafi.

$100 USD in 10 days
(1 Review)
2.0
sunsriinfosys

Hi, I have over 10.5 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web designing using Photoshop, Flash, Web and ERP ap More

$200 USD in 5 days
(1 Review)
2.0
freelancerbuzzo

Ready to do this work immediately.

$50 USD in 5 days
(2 Reviews)
1.2
sarita81

Dear Sir, I can do it for you. Please check my profile at [url removed, login to view]

$150 USD in 3 days
(1 Review)
1.0
njlgil

Hello, If you don´t get what you want with this project, then contact me. Regards njlgil

$30 USD in 1 day
(0 Reviews)
0.0
SharifIbtesam

Please chk ur PMB for details

$100 USD in 4 days
(0 Reviews)
0.0