Hi all, I am new to this site...
I have a console application written in C# which insert one table info to another table of an access database. There is a date table in format(4/30/09) which I like to insert into another table with the format 4/30/09 03:26:PM. Can I do this in a single query... here is my query

Insert INTO trcheck01(M_CDATE,M_CHKAMT,M_CUSTNO,M_CHKNO,M_CKHCUST,m_cfile,M_CFDATE,lngSequence) Select M_DATE,m_amt,M_CUSTNO,M_CHKNO,M_DRACTNO,m_file,M_DATE,lngSequence FROM trtrans99";