@david.wylie already answered about how to upload files.
If you instead want to copy data from a local database to an anvil table, you can use an uplink script, which allows you to run a script on your computer that works on anvil tables as if it were running on the server.