I am trying to import a .txt file which contains date columns into an on-prem SQL Server. The tool seems to have issues detecting fields that are dates. What is the easiest way to detect date columns in a .txt file?
Hello Matt, and welcome to the Community!
The typical way is import dates from a text file as text values and then convert them into number dates using the “Convert data types” action.
Alternatively, text values can be converted into dates using an expression with the date() function.