>>You could be in trouble there if Tables[0] has no rows :-}
>
>Well, yes, of course ... I figure Tim's smart enough to put in the extra code that's needed. <g>
>
>>But anyway, by definition, all of the other Rows in all of the other Tables will still be 'Unchanged'. I think Tim needs to explain what he expects to happen to this data in relation to the new destination - won't the rowstate for each row have to depend on whether that row exists in the new destination?
>
>Yes, well, we certainly have no idea what Tim intends to do with the DataSet, so this may or may not work the way he intends ... but, I simply answered the question he put forth and assumed he knew what he was going to do with the DataSet after that. <g>
>
>But, hey ... Tim ... what *are* you planning on doing with that DataSet?
>
>~~Bonnie

Well Mike I don't know what "Deft" means so I can't respond to that part. But as for the rest of it here is my explanation. I am pulling a dataset from a SQL Database and I want to move into a VistaDB table with the exact same structure. So what I need to do is fill my dataset from SQL server but when I try to then set that dataset to be saved to the different datasource it will not save because nothing was changed. There could be 25 rows or some tables may have a couple thousand rows. I would prefer not to loop through the rows but it isn't a big performance hit in this case. I have several tables that will need to be exported so I have a selector to pick the tables to be moved. I just need to figure out how to put the dataset in a state that will allow me to save it all again.
Thanks for any help
Tim