since you can't open it, I would kick it back to the sender requesting them to separate the data some how so it can be more manageable to work with.

As for the .NET app, I made it read the XML file and parse out the data based on the xml tags and inserted into the tables. it was something like SqlBulkCopy to do the process.