I don't have experience with many DB's, so apologies if this is an obvious question.
Just learned that SQL Server allows importing files with variable columns into a table. So if table exists with 5 columns, then
Col1, Col2, Col3, Col4, Col5
aaa,bbb,ccc,ddd,eee
111,222,333...