Import text file with ISO 8601 date/time values (2014-07-02T16:09:49-07:00) <p>When importing a text file into Access 2007 with date/time values like </p> <pre><code>2014-07-02T16:09:49-07:00 </code></pre> <p>Access is unable to convert to date and shows the same as text. How do I convert the same in to date/time in Access?</p>