Advice on exporting a table to a CSV

[TonyD1016]

I am a novice when it comes to Access but I have an Excel spreadsheet that has grown much too large for Excel to manage and I am in the process of migrating it to Access. I believe I have all of the fields set up correctly but the problem is that I need to be able to export the table as a comma-delimited text file. I am fumbling my way through creating a specification using the Export Text Wizard and I need some advice.

I have a field for daily employee clock-in and clock-out data that is stored as Short Time so it is displayed in 24 hour format, and additionally stores the date along with the time. I really like having this as an option for queries, however when I go to export it shows the time as hh:mm:ss as well as the date. I need it to export the short time as hour and minute and leave out the seconds and the date. I have a similar problem with a field where I enter the employees date of birth. I keep it stored as a date but when I export it I need it to appear as "yyymmmdd" with no additional formatting. I've selected the YMD under date order and left the date delimiter blank to do this, but it also appends a time of 0:00:00. How can I make it leave this time out entirely? Would it be better to store the DOB as a short text field instead?

 

[Joe4]

You can use the FORMAT function in your query to convert these entries to Text values in the exact format that you need.
If they are Text, they will not be converted when exporting to CSV.

See: Format Function

 

[Micron]

FWIW, I'd say that it's rare that a spreadsheet makes for a good db table. You might get this figured out only to find that it's horribly un-normalized (is that a word?) and you have a tough time doing anything with it. If you are not familiar with database normalization I strongly suggest you look into that before doing anything else.