I have a DBF file with 1400+ rows and 32 columns and I need to write this to an Access DB table. The Access table was created by modifying the original structure of the DBF table in which I removed 12 unnecessary columns.
I have been successful at loading the entire DBF table into a DataTable and now I need to Update the Access table with the necessary column data. Fortunately (I think) the necessary columns are the first 20 in the DataTable.
Is it necessary to loop through the DataTable row by row or can I write the entire table in single command with NET thru CommandBuilder.
I'm not familiar with the Update aspects and eventually I need to repeat this process about 270 times.
Need some help on this Update command, appreciate some input.