G
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.
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.