First time creating a simple db

[yellowdragon]

I have problems importing data. The errors are with the date fields. When I change the date fields to text it seems to work fine. The date is imported as text is this format, 2012-07-24. I tried all kinds of different setting but this is the only one that I could get to work. I think I'm ok with the fields all being text. I would guess that I need to change the fields in any of the other tables that are being updated by this table to text?

[jzwp11]

If you are importing the data into a temporary table, you can use a query to change the date to the format you want prior to appending it to your regular table. If you are importing directly into your regular table then you either have to change the source data prior to importing or run an update query after the append. In any case, I would strongly recommend that you have the same datatype for all data fields throughout your all of your tables. If you keep the date as text, it would be best to convert them to dates as you need them. Likewise if users enter dates as date,you would have to convert them to text. How do you want to display dates mm/dd/yyyy format? dd/mm/yyyy format.

BTW, Access stores dates as a number with the portion to the left of the decimal point representing the number of days since 12/31/1899. The portion of the number to the right of the decimal point is used for the time and is stored as a fraction of a day (i.e. 0.5=noon)