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
Project Budget$30 - $250 USD
Completed In2 days
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"
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online