How to export date from Access without time (need space delimited fields)?
Posted on 2006-06-23
I need to export data from Access with spaces to delimit the fields and quotes (“) as the text qualifier. I have a problem with the date field. I get date + time. I only need the date. How do I get Access to export just the date? If I convert it to text, then I get quotes around the date (which won't work when I import it into my accounting system). I am going to file, export, text, delimited. I then choose space for delimited and " for the text qualifier. I need this to fix payroll for a retro union wage change.