hey all,
i have an Access Database with about 43,000 records in it. I need to take 2
or 3 columns and modify them and update the database.
currently what i'm doing is loading all into a dataset and making changes
and pushing it back up to the database. it seems kind of a long process about
20 min.
am i better off using Access Query or SQL Server query to modify the data or
is there a faster way in vb.net? All, i'm doing is formatting date fields and
concatenating 1 other field.
Please advise.
Thanks,
rodchar