URGENT Please move from table to other table

[sal21]

I have Table1 and Table2 in access database.
In Table1 have 6 fileds
But filed1 and filed2 are Text formatted with a dates similar dd/mm/yyyy.
In Table2 have the same structure of Table1 but the filed1 and filed2 are formated Short Date.

How (whit a ADO query) to recopy copy from Table1 to Table2 all records and convert directlly the filed1 and filed2 in the new format date ????

[HansV]

Sal,

This board is run entirely by volunteers who try to help if and when they can; you can't demand immediate help.

Date formats such as long date, medium date and short date are for display purposes only. In all cases, the date values are stored the same way. So there is no need to treat the first two fields separately. You can use a query with SQL:

INSERT INTO [Table2] SELECT * FROM [Table1]

[sal21]

i'm very sorry for "URGENT MESSAGE" but i'm into the "panic"...
I cannot test now, but sure yiu suggestion work fine!
Tks again.