How to download file from URL manually?
You could keep it really simple by using something like file_get_contents() to retrieve your file and save it on somewhere on the servers filesystem, presumably /sites/default/files. After that, you can put in the database whatever you want.

The thing is, drupal won't know what to do with that in most cases. Files in drupal must be associated with a file field. That's the way things work.