VBA MSAccess - CSV File

This project was successfully completed by KellogITSolution for $40 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
2 days
Total Bids
Project Description


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


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


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online