Avatar of Rob4077
Flag for Australia

asked on 

Transfer database Date format confusion

I need to transfer a number of tables from one database to another and found what I thought would do the trick by using a Docmd.transferdatabase method to create a multi tabbed spreadsheet with each sheet being one table. Then I ise the same method to import the spreadsheets into the new database. Problem is that when I run the import and it comes across a date in the system date format of dd/mm/yyyy it tries to import it as mm/dd/yyyy and so fails to import. Does anyone know a fix?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon