Synch between Excel CVS <-> SQLCE

  • Thread starter Thread starter AAA
  • Start date Start date
A

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
 
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.
 
Back
Top