I would like to import a file into a Database table. The file has no column headers and 160 columns. The columns will remain in the same position in the file. Currently, I am doing this by manually mapping the columns using the Import process in SQL. As this is going to be a regular requirement, is there a way to automate this process?
Any guidance would be appreciated.