AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
I export a query to txt format and one field on the query is a date. On the main table the property for thet field is set to Date/Time. When the export is performed I get the date followed by 000000 but I must only have the date. Is there a way to export just the date and not the time? The work-around is to use search&replace in a text editor but that is pretty primitive.
Th database contains records of stock prices and the query extracts stocks from a particular market. The csv file has to be in a particular format to be processed by other software that eventually produces a data file that is imported into charting programs like Metastock etc. As I do not have control over the way the special software reads the csv file I have to make the file conform to what is already expected.