Your tags claim that this is about SQL-Server-2014 while your text claims that you're using MS Access.
If I assume that your tags are correct I'd tell you use
Unpivot[
^].
But if you indeed are using Access there is no Unpivot available. So then you have (atleast) four choices. And I don't think you'll like any of them.
Either you can load the file to a staging table and unpivot manually:
Select Applicant,School0 as school from stagingtable
union all
select Applicant,school1 as school from stagingtable
union all
select Applicant,school2 as school from stagingtable
union all
select Applicant,school3 as school from stagingtable
... repeat 1300 times
Or you can install a real database and use unpivot.
Or use a real database as a staging area where you unpivot, then export the data to your access database.
Or you unpivot the data in a program before importing to the Access database.
<edit>Trying to answer your followup question.
The problem is that there is a maximum of 1024 columns in a table. But you can make inserts and queries with up to 4096 columns.
So there are again several choices to make, and one of them you have already seen yourself.
- Import the file into three different tables having the same primary key, join the tables together into a subquery or a view where you do the pivot instead.
- Import the file into a Wide Table[^]. The problem with wide Tables is that they rely on Column Sets and when you query a column set you get the result as XML.
- Use a Fast CSV Reader[^] to get the data rows into a program where you split up and insert the data into the appropriate dbtable.
- Combine 1 and 3.
</edit>