I have text file which is non-delimited, and I need to import it into my table.
Table is: CREATE TABLE TempTable
and my import file:
I need to import first 10 characters to Field1 column, next 10 to Date1, next 10 to Field2, and next 5 to Number1,
I've tried with openrowset and format file, but doesn't work