Synch between Excel CVS <-> SQLCE

[AAA]

Hi, I am wondering if there are better way to synch the data between Excel
CSV and SQLCE ?

Or manually create two buttom and allow user to pull and push is the best
way so far ?
So, everytime user want to update SQLCE data to the current CSV file. users
have to deleted old data, then insert all again.

Pls advise me. thank you very much

 

[W.G. Ryan MVP]

How are you reading in the excel file? Are you using PocketExcel? Probably
the easiest way is to fill a datatable and use the AcceptChangesDuringFill
property to false on it, then point it to the destination and call Update on
the same datatable providing a valid insert command.