I want to import text documents into sql however it doesn't come in a CSV format and I cant change this.
we receive all files in the attached format. The only thing is that the amount of rows of data between each column can change. I want to insert all the lines of data into 1 column with just a space between line breaks. Is this possible and how would I go about doing? I have basic knowledge of SQL but nothing advanced.
data data data
company name goes in here
around 10 lines of notes could be placed into here.