How would I get the last column of the below text table into an SQL field that is a datetime field? The first two columns are imported into varchar fields. The last column needs to be converted into a datetime.
cast(thatpart as date)
will work, as the format yyyymmdd is implicitly ok.
see also this article:
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…