I have one sql table and one MS excel file. There are appro. 140 members in the MS excel table and 189 members in the sql table. Most of the members in these tables are repeat so total data would be appro. of 190 members. You could recognize the repeated member's detail from their name. The data is basic members' entries such as name, address, year etc.
I have a new sql table with fields. I just need to bring entries from these old tables to write into the new sql table as per the new table fields. I will provide you an excel file and one old sql text file in which you could see table fields and dumped data you have to write the dumped data into new sql table dump as per new fields. I will assist you in case you won't understand something.
As this is a very small job of just writing data from one table into a new table according to the new fields (which are appro. same except a few changes), My budgest is $10-15. This is just a one day job but you could do within 5 days.
Hi no excel file, you will get only one file with 189 members details in simple text sql file so you have to enter data into a new sql file table fields only for these 189 members. this will make your work more easy because the excel file data is too messy to handle so I don't wish to send that file and most of the members in that are repeat no point going for that. thanks!