Date issue exporting postgres database to Access 2010
Posted on 2012-04-05
Postgres version 8.3
Connecting to the postgres database via their ODBC driver using Access 2010, I used the Access 2010 import wizard to pull over the patient demographics table. The problem is that all the birthdates look like this in Access:
Obviously, this isn't going to work. I need 11/21/2001 and so forth.
Am I doing something wrong? Is there anyway to get the birthdate to come over the way I need it to?
Thank you all in advanced for your help.