I'm working on a solidworks database program (vb2008expr).  The program gets the specified values from solidworks, fills the dataset.... This all works fine.  The problem comes when I want to add this to my database (access).  I can successfully run dataadapter.update... but it takes its sweet time doing so.  I have been told that calling the commands as a transaction is a much faster approach (~10x faster).  I'm having trouble building my sql statement for the update command.  I want to update, from my dataset, all columns & rows into the database.

From what I've been able to gather, the sql statement: "UPDATE tableName SET x=y" is used to update specified values. ie- change all values of column1 to x.

How do I build the correct sql statement for what I'm trying to do.  Or is there another way of quickly overwriting the database with the dataset info.

Thanks