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"