Keep Short date format when exporting a table

[Guest]

I am attempting to generate a csv file for importing sales data into another
database application. I'm using Access to translate imported data from a web
based SQL on-line shopping cart.

The application which will be importing the csv file needs a short date
format for for the order date field.
The generating SQL database generates the order date field as Date & Time
(6/22/2005 7:00 PM).

I'm using a make table query to sum by date and create a table which I'll
export into a CSV file. I've set the format on the newly formed table to
have order date formated as "Short Date", but when I go to export the talbe
to a CSV file, the date and time format returns (6/22/2005 19:00:00). Any
idea how I can keep the short date format (6/22/2005) and lose the time?

Thanks in advance to any and all replies.

 

[Rick Brandt]

I am attempting to generate a csv file for importing sales data into
another database application. I'm using Access to translate imported
data from a web based SQL on-line shopping cart.

The application which will be importing the csv file needs a short
date format for for the order date field.
The generating SQL database generates the order date field as Date &
Time (6/22/2005 7:00 PM).

I'm using a make table query to sum by date and create a table which
I'll export into a CSV file. I've set the format on the newly formed
table to have order date formated as "Short Date", but when I go to
export the talbe to a CSV file, the date and time format returns
(6/22/2005 19:00:00). Any idea how I can keep the short date format
(6/22/2005) and lose the time?

Thanks in advance to any and all replies.

Use a query that contains the Format() function to output your date in the
desired format and export the query instead of the table. Format
*properties* are never retained during export operations.