CSV Export report not working

[Gasman]

You merely Export as text, select comma delimited (which is the default) and give the file a csv extension. You can also save the Export details as a specification and then use that from then on.

Our NGO, has Office 2007 CDs from which we had only been using 2007 Word.
We installed the Ms Access program, but when doing an export test, we can not find a CSV exportable portion.
Please advise, where this CVS extension is in Ms Access Office 2007?

Thank you,
Nicole

 

[access2010]

Thank you for your suggestion.
A copy of what we are doing in Ms Access 2003 is attached.

Can we programmaticly create a CSV file as we need one every Monday morning and if yes could you suggest a code for our report = Stock_PortfoliobyAsset_SymbolsR

Thank you,
Nicole

 

[Gasman]

From the experience in the office, I think you should upgrade to 2007.
That would allow you to create the spec for the export and save, then use it each Monday with a line of code.?

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transfertext