fill an access table with a dataset

[pankajdaga]

Hi everyone, I am using ADO.NET with Access. I have a dataset filled from a data source which has one-to-one correspondance with an Access table. I would like to know what is the most efficient way to fill the Access table with this dataset. Should I iterate through the dataset and call SQL inserts?? I am hoping there is a better way. Thank you for any help you might give me. Sincerely, Pankaj Without struggle, there is no progress

[dishanf]

Did you tried to use Table Direct for Fill data set D!shan

[pankajdaga]

Hi, I am sorry I do not understand what you mean. Could you please elaborate on it? My problem is that the dataset is filled from an SQL server database. Now I need to dump the contents of this dataset in an Access table. So, I would like to determine which is the most efficient way to do this. I can of course call an UPDATE statement for each row in the dataset, but I have a feeling that there might be a better way :D Thanks, Pankaj Without struggle, there is no progress

[dishanf]

Hi You can build a multi sql statement and execute it once!. you dont need to execute singel insert / update statements many times. Ex. sSQL = "INSERT INTO .....;INSERT INTO ...;INSERT.." executeQuery( sSQL ); HTH., D!shan :cool: