How do I automate a reoccuring data load from Excel to Access?

Discussion in 'Microsoft Access External Data' started by Andrewrccl, May 12, 2008.

  1. Andrewrccl

    Andrewrccl Guest

    I need to update an Access database weekly from an excel spreadsheet
    generated from one of our systems... In doing so, there is some basic
    transforms to do one the data before it is dumped in...
    Is there an easy/good way to do that?

    thanks!!
     
    Andrewrccl, May 12, 2008
    #1
    1. Advertisements

  2. Andrewrccl

    Klatuu Guest

    One way is to link to the spreadsheet as if it were a table. Then use an
    append query that can do the data transformation and append records to your
    Access tables at the same time.

    It may be necessary to use recordset processing to do this if the
    transformation can't be done with SQL. But, avoid using any make table or
    temporary tables as they are big contributers to database bloat.
    --
    Dave Hargis, Microsoft Access MVP


    "Andrewrccl" wrote:

    > I need to update an Access database weekly from an excel spreadsheet
    > generated from one of our systems... In doing so, there is some basic
    > transforms to do one the data before it is dumped in...
    > Is there an easy/good way to do that?
    >
    > thanks!!
     
    Klatuu, May 12, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page