How to create a CSV file which imports data from an Access Database on a Weekly Schedule?
If I understand your question correctly ... you are trying to store the Report Date and Sales Value in a CSV file on a weekly schedule.

Why not save this information in your database? Have a scheduled job run a query to produce your sales numbers. That scheduled job would insert the Report Date and Sales number into a database table. That way you don't have the sales numbers in an external CSV file.

When you want to check the report date you just have to run a simple query to pull back that information. Let me know if I'm missing the boat.

*** EDIT ****
In your post you said "I have access to a database". I suppose I should have first asked if this was an "Access Database" or a "SQL Server Database".