I recently moved from Access 2003 to Access 2010. Frequently (about 20 times
per week) I import .CSV files from several different data sources. One of the fields
is a date, stored as text with a leading zero.
In Access 2003, I had no trouble as the text appended to an empty copy of the
table where all fields were defined as Text.
In Access 2010, even though the table has all fields defined as text, the
checkbox for Leading Zeros in Dates must be ticked EACH TIME or Access will drop
the zero.
I've looked through Options and browsed through the registry but have found
nothing that suggests a permanent default.
Has anyone discovered a way to set this ON permanently?
Thanks for your attention.
-C
Windows 8 Pro with Media Centre, MS-Access 2010 - 64 bit
(Screenshot.jpg)
---