Im am trying to set up a data-integration with a diamond vender so that I can make a diamond search application.

they said they can place a file on my server via ftp everyday in any format I want with the data.

so what I want to do is make a table on my DB to hold this data and make a script that can take that file and update the entire table with all the information from the file.

the problem is I dont know how to make a script to do that or what kind of file I would need.

If anyone can shed any light on this I would really appreciate it.

(By the way there will be around 40,000 diamonds/rows passed)