Even i have faced the same problem. When i tried giving the Physical location (F:\Folder) on that server rather than the (\\Server\Folder ) it worked for us.
Since the data file is not a standard format one, your first attemp should be to format it according to the need and then use it. The solution i like...