K
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 thinks 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. I do need the temp table. The data from the excel sheet does not all
go into the same table.
"8/9/04 1:25:43 PM EDT" Access thinks 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. I do need the temp table. The data from the excel sheet does not all
go into the same table.