CSV Export report not working (1 Viewer)
- Thread starter access2010
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 08:19
- Joined
- Sep 21, 2011
- Messages
- 14,232
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.
access2010
Registered User.
- Local time
- Today, 00:19
- Joined
- Dec 26, 2009
- Messages
- 1,021
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
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
Enthusiastic Amateur
- Local time
- Today, 08:19
- Joined
- Sep 21, 2011
- Messages
- 14,232
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
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
Similar threads
