I am writing some Visual basic code that needs to create a M$ Access DB with a table that has a DATE ROW with dd/mm/yyyy in the Format as you would see in the general tab of the table-view. e.g sql = "CREATE TABLE DailyTbale ([R_Date] DATE(dd/mm/yyyy)" That type of thing. ?? Any Takers ??