Situation:
My Suppliers have the inventory list in an excel file (.xls) and some also have them listed under .cvs.
Problem:
I am looking at a way to automate the website and have it updated from the suppliers on the products/quantities. Not all my suppliers have .cvs files for download and I was hoping there is a way to have my website check the suppliers and read those files. Any ideas?
I assume you mean CSV (Comma-Separated Values), not CVS (Concurrent Versions System).
You can try using PHP Excel Reader (http://sourceforge.net/projects/phpexcelreader/). Never used it myself though.
Alternatively, if you have access to a Windows machine with Excel installed you could probably use JScript or VBScript to automate the process of opening the Excel spreadsheet and saving it as a CSV file.