Hi, Bonnie
Thank you for your time. Unfortunatelly, it doesn't. I didn't design the application and there is no table. Actually, the original code was a string concatenation to build an SQL command. Problem is the values could contain invalid SQL characters (such as '), but perfectly good data, and I tried to overcome this problem by adding the values as parameters to that OleDbDataAdapter.
I'm kind of stuck.
Thanks
>To add rows to your DataTable, try this on for size:
>
>DataRow row = MyTable.NewRow();
>row["MyColumn"] = "whatever";
>MyTable.Rows.Add(row);
>
>I don't have any particular step-by-step to recommend off the top of my head. I don't think I have anything good bookmarked at the moment. But, maybe the above example will get you started?
Grigore Dolghin
Class Software.