HawkCode

Hi, I'm trying to import a CSV from an Access query and keep getting the error: [Err] 1292 - Incorrect datetime value: '' for column 'DateEntered' at row 1 here is a sample of the data: [!--fonto:Courier New--][span style=\"font-family:Courier New\"][!--/fonto--]1,"Mr.","Donald","F.","Dickerson", "P.E., CIPE","Estimator",,1/23/1997,"Import" DATE ENTERED IS--------^^^^^^ [!--fontc--][/span][!--/fontc--] I've tried it delimited with "," TABs all same result. Anybody got any ideas. TIA Rich