database acces + sql + .txt

[dextrometofan]

it just didn't give any record, no error msg

from the link

  For most versions of Access [and other Jet databases] (others versions use ' as above)
Select * 
From myTable
Where dateField = #01/01/2006#

is it MM/dd/yyyy or dd/MM/yyyy

bytheway, what kind of datatype in acces to save "time"??
string or date??