Answer to Question #14328 in AJAX | JavaScript | HTML | PHP for kirthika

Question #14328
How can i add records after the existing records in the existing excel file using php?
Expert's answer
The simplest process is a clone copy of the target table, with a relationship to the real table based on whatever field or set of fields constitutes a verifiably unique identity (i.e., makes it a duplicate or not). Import all recs into the clone table, then loop through the found set; if there is no corresponding record in the live/real table, mark it, otherwise don't mark it, go to next, exit after last, end loop. Then find the non-marked records, delete them all. Then either write out the marked ones (with a series of Set Field script steps) to the live/real table or export them as a batch to an Excel file or a Merge file and then turn around and import them into the live/real table. Finally delete all recs from the clone table since it's just a holding tank.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

New on Blog