Search results

Hi folks, I have an Access 97 database that is populated from an excel spreadsheet. The excel macro inserts the data into the database but access changes the date format. The field in Access has a format of dd/mm/yyyy and my regional settings are set to UK. The excel macro exports the...