If you can get a connection to that database, just use "File|Get External Data|Import".
Since that is probably unlikely, ask them to send it to you in a file with a regular format (Excel works great). Then use the same method or automate it in VBA using "Transferspreadsheet()".
You didn't really give us a lot of information to work with.