MS Access 2003 - Modifying a date-time column into a different date-time format?

Question

Hello! My problem is that I have a csv file containing columns with values that look like this: 1/25/2007 10:20:36 AM. I need to modify these columns to have values that look like this: 2007-01-25 10:20:36 or simply 2007-01-25. The file has 67 columns and over 1.5 million rows. Even MS Excel 2007 only has 1.4 million rows. Since I've never used Access before, I'd appreciate step-by-step instructions on how to save my file with the desired date-time format if anyone knows. Thanks!!

Answer 1

In Excel 2007 it can be easily done. But I don't have 2003. Try to do this nonetheless.



1. In the Field Properties box in the bottom of the screen, click on the General tab and then on "Format."



2. When you click on "Format," an arrow will appear on the right side. Click on the arrow to obtain a menu of format choices.



3. Select from General Date, Long Date, Short Date. These ones won't give you the yyyy-mm-dd format. Can you customize by going to custom symbols? In 2007 you can type yyyy-mm-dd, but I am unsure about 2003.

Answer 2

Create a query with the fields you want. In the date field, type ColumnLabel: Format([datefieldhere], "yyyy-mm-dd")



Save the query and export it to excel.

Answer 3

A database can run on only approximately any laptop. Oracle has a easy-weight customer talked approximately as Oracle show version it is stable first of all. MySQL is yet another common database. as quickly as you have certainly one of those databases put in the thoughts open up. OracleXE has its very own layout procedures. I especially use the command instantaneous for the MySQL occasion. SQuirreL is a reliable piece of utility to controlled databases. i'm needless to say approximately open source and loose utility. yet once you're in seek of for a much bigger gadget. paying for committed servers on your database and dealing a heavy weight Oracle gadget is often an selection.