The problem isn't in keeping the data type. Make Table queries delete the existing table and create a new one, so the problem is in making it create the correct data type.
Modify your Make Table query so that the source for the date/time column is of date type. The simplest way would be to change the Field: row to a CDate() expression. (I'm assuming all of the source rows have valid dates present.)
You could also use an Append query instead, since you have created the table ahead of time.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein