Exporting table Date/Time field - How do you REMOVE time

G

Guest

In Access 2003 TIME is appended to the Date field during an export, even when
there is no time. "DD/MM/YYYY 00:00:00" Is there a way to get rid of TIME?
Help. Was not an issue in older versions. Table is created off another table
via MakeTable query.
 
D

Douglas J. Steele

Create a query that uses the Format function (as opposed to simply setting
the field's Format property) and export the query.
 
G

Guest

Doug, Thanks. This only makes the field a 'text' field and is then in
double-quotes upon exporting. Really wanted to use a 'date' field in the end
table. Used to work in Access 97 just fine. Any idea on how to correct the
IISAM(sp?) or setup a schema.ini? The export spec doesn't really help. Gotta
love enhancements.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format Incorrect on Export 1
XML File - Date field formatting? 1
Export Date to outside system 5
Exporting time with date 2
Export Date without Time to text tab delimited file 3
separating date and time 5
Export screws up date format even in one table database 4
Access General Date Forced To Have Date And Time 2

Top