Is there some magic that pulls in the file?
Not really.... just do a BULK INSERT from the file. I haven't had the time to post it but you should have no issue. Make a temporarry target table should have a RowNum columns as and identity and a 500 character "DataFromFile" column. Then just change the code to read from that Temp table instead of the VALUES() clause.