I need to do some analysis on data from our trouble ticket system. I can get the data out in a .CSV file (no ODBC connections are allowed). When I import into an Access table, it will only import as Text. I need to convert some of the fields to Date/Time in order to measure how long tickets stay in each stage.
I've tried building the table first with the proper fields set as Date/Time, but I receive import errors for every field marked as such. I've tried removing the quotes around the entries in the .CSV file, but that didn't work either.
I need an update query that will convert the field from Text to Date/Time. I've looked through an Access book, searched the web, etc... but the proper syntax is eluding me.
In case you couldn't tell, I'm such an Access newb. I'm a Sys Admin, we don't do apps...