Date Format

[KAnoe]

I have an Excel sheet that I get that comes with the following date format

8/9/04 1:25:43 PM EDT

Access makes it a Text field. I put the data into a temp table and delete
all the data after the year and then copy and past it into a Date field then
move it from the temp feid to the main table.

I would just like to put it into the temp table and then move it to the main
table. The data from the excel sheet does not all go into the same table so I
will still need the Temp table.

Thanks

 

[Ken Snell [MVP]]

Use an expression similar to this to convert that temp field to the regular
field when you do the append query:

CDate(Left([TempDateField], InStr([TempDateField], " ") - 1)