>- see footer for list info -< Hi All, Just wondering if anyone can recommend the best way to capture information from an uploaded excel spreadsheet or CSV file, is there anything in particular I should be looking out for, which one is the best format, delimiters etc?
We are building a system and can define how we want people to supply the information so easiest options are what we are looking for. Thinking along the lines of a CSV file which gets saved to a directory and is then read into a variable, the variable is then read line by line using the CRLF as the delimiter (columns and headings would already be defined) and then doing a DB insert assuming the line conforms to the expected criteria, i.e. the number of columns and column length etc. Using CFMX hosting as the host with a semi dedicated server so custom tags might be an option. Any help is appreciated. Regards, Lee _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
