hey everyone,
instead of having time to code it myself, i'm wondering if someone has a script i can easily edit myself to do the following.
browse for xls file to import into mysql
code would have to be customized i'd guess to match xls columns to database columns
have add/update functionality. if a certain primary key is chosen (could be hardcoded to email field), then a search is done for this entry. if this entry exists in the database, the data from the xls record updates the existing entry. if not, it would simply add a new record. HOWEVER, one big thing, if the xls file has blank cells for certain columns (besides Email of course), those blanks would be ignored. that is, blank xls cells during an update WOULD NOT overwrite existing database data. that's super important for me.
that's all really...i'm super busy, don't have the time to do this. if someone does, please let me know.
