I am trying to import data from a tab delimited text file into a local table in our test system. The table has an int column and a datetime column that allows nulls, however, I keep getting errors for those columns when I try the import. How do I specify null values in the int and datetime columns of the text file? I have tried NULL, ‘NULL’ and ‘’ and none of those worked.
Penny