Post reply

Mismatched excel and access column headings

  • April 22, 2005 at 4:52 am

    #66199

    Related to my previous post....

    I need to transfer data from excel into access on a weekly basis. There are spaces in the column names in the spreadsheet. How do I insert these excel values into access table. At the moment the table is linked to the spreadsheet and I created an intermediary table to perform as I want to make some changes before transferring into final table.

  • April 22, 2005 at 10:03 am

    #554375

    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 2 posts - 1 through 1 (of 1 total)

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