Wrox Programmer Forums
|
Access Discussion 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
 
Old February 19th, 2004, 01:00 PM
Registered User
 
Join Date: Nov 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Export csv

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.

GRPinkney
 
Old February 19th, 2004, 02:33 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What are you going to do with the csv file?

Clive Astley
 
Old February 19th, 2004, 03:08 PM
Registered User
 
Join Date: Nov 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

GRPinkney
 
Old February 21st, 2004, 07:35 AM
Authorized User
 
Join Date: Jul 2003
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try picking out the date part of the field as a calculated field in the query, e.g. Left([yourDate],10)


Cheers Ray





Similar Threads
Thread Thread Starter Forum Replies Last Post
DataSet export to .csv file snufse1 ASP.NET 2.0 Basics 3 September 22nd, 2008 07:22 AM
Csv Export Coby Access VBA 4 July 25th, 2007 08:19 AM
How do I export data from a DataViewGrid to a CSV pauljohns353 VB How-To 1 November 22nd, 2006 11:57 AM
Export To .csv File paul31Hampshire Access VBA 18 June 26th, 2006 11:30 AM
More Export.csv mayhem Morris Access 1 February 24th, 2004 12:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.