Upload

I'm not 100% sure I follow this. As a general suggestion you can use BeforeInsert event to insert data manually:

http://xlinesoft.com/phprunner/docs/before_insert_record.htm

Its not the file i want to change. Its the way the file uploads. My client has 5/7 ++ different files to upload from different suppliers all with similar information. I would like the following to happen

• Firstly I set up a table titles in database = title on the form. i.e i have a date title on my database but the spread sheets my have start, start_date, meter date etc. so the table would read col 1 supplier = supplier 1, col 2 date = start_date, col 3 .....
• in the above selection we would also state in a row_start col the row of the header i.e header is on row 5
• On the import page i will have a drop down box, on selection the import page will load with ?supplier=1.
• The user will navigate to the correct file
• The import will then select the template and select start_date in start col starting on row 5
• If the file is wrong a nice error message will display

Basically i want to dynamically create a process to import the same data types in to a table using different .xls sheets
So I wanted to :-
If their is no easy solution for this please give me a quote in my personal email
Thanks for all you guys do
Richard[/font]