Mismatched excel and access column headings

  • What you can do is
    (1) get the contents of the excel into a dataset and and parse through the contents of dataset and modify them.
    (2) Then you can have another dataset mapped to the access table.
    (3) copy the first DS into the second one.
    (4) Update the changes into the access table.
     
    you can also parse each row and insert it into the Access table but you'd be making N trips to the server ( N=number of records in the excel sheet). with the dataset approach all the records are updated in one trip.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply