[snip] Does anyone have any resources or links as to how to import a spreadsheet but it might have different number of columns and many sheets (those tab things at the bottom). What I thought of doing was creating a table that has 10 fields and if the file thats being imported only has 4 fields then the remaining six fields are blank. So basically my script must dynamically take the format (which changes) and try save it in the database in a semi standard format. If anyone thinks its possible or not please advise. Any help or advice would be greatly appreciated. [/snip] Sure, it is possible but which data goes in which columns? A four column spreadsheet does not have the same textual context unless you make everyone start with the same 10 column spreadsheet and place their data in the right columns. If you are trying to save individual spreadsheets as data that are independent of the data in the other spreadsheets then that sort of eliminates the need for a database, but it can be done. You have to have a column or two that would contain the spreadsheet identifier and a date. Then your table could have as many columns (generically headed) for data. spreadsheetName date col1 col2 col3 col4 ... sales 2007-07-25 data data data data ... sales 2007-07-25 data data data data ... mileage 2007-07-25 data data mileage 2007-07-25 data data For each spreadsheet you would have to insert a row to hold column headers for that spreadsheet, so you may need a third column to designate what kind of row type (header, data) this is for that spreadsheet. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
