<div>
create a query with this column<br />
assuming the field name is dteField<br />
<br />
select dteField, cdate(left([dteField], instr([dteField], &quot;&nbsp;&quot;)-1)) as YourDate<br />
from tableName
</div>


create a query with this column
assuming the field name is dteField

select dteField, cdate(left([dteField], instr([dteField], " ")-1)) as YourDate
from tableName

<div>
Aha! You nailed it... it's just the &quot;&nbsp;EST&quot; that was keeping Access from recognizing the data as a date.<br />
<br />
Thanks for your help!!!
</div>


Aha! You nailed it... it's just the " EST" that was keeping Access from recognizing the data as a date.

Thanks for your help!!!

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I have a process in MS Access that imports a downloaded CSV file into MS Access using docmd.TransferText, but the date fields are not recognized by Access. I've tried a couple of things to convert these dates, but nothing has worked so far. The imported date values look like this:<br />
<br />
12-Feb-2015 08:12:28 PM EST<br />
14-Feb-2015 02:57:23 PM EST<br />
<br />
I'm importing the list into a working table, and the field to receive that date value is of type Text; I tried setting it to date/time, but then access just refused to import that fields' data. I then added an extra field at the end of the working table and have tried various formats and functions to manually push the date into that field, but I always get an error about mismatched field types.<br />
<br />
How can I format this date value so that I can sort these records chronologically?<br />
<br />
Any help would be much appreciated!!!!<br />
<br />
--J
</div>
</div>


Hello, 

I have a process in MS Access that imports a downloaded CSV file into MS Access using docmd.TransferText, but the date fields are not recognized by Access. I've tried a couple of things to convert these dates, but nothing has worked so far. The imported date values look like this:

12-Feb-2015 08:12:28 PM EST
14-Feb-2015 02:57:23 PM EST

I'm importing the list into a working table, and the field to receive that date value is of type Text; I tried setting it to date/time, but then access just refused to import that fields' data. I then added an extra field at the end of the working table and have tried various formats and functions to manually push the date into that field, but I always get an error about mismatched field types.

How can I format this date value so that I can sort these records chronologically?

Any help would be much appreciated!!!!

--J

Import excel dates into access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.