access database: automatic update??


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: access database: automatic update??

  1. #1
    jackal Guest

    access database: automatic update??


    I am a beginner(a student as well) to database programming.
    I am doing an automatically updated database which imports data from an excel
    spreadsheet. The excel spreadsheet is doing a web query and the data inside
    is changing every minute in real time. I would like to ask how can I update
    my access database automatically every minute by appending new records??(using
    macros? or write vba procedures? how?)
    (I am able to run the macro manually but I would like to make it run automatically
    after certain interval.) due to there is interior setting in access that
    perform such a execution.
    I hope your all can help me.
    Any suggestions ang ideas are highly appreciated.
    Thanks

  2. #2
    Douglas J. Steele Guest

    Re: access database: automatic update??

    Why bother? You can simply link Access to the spreadsheet (as opposed to
    importing the spreadsheet into an Access table), and it'll always use the
    most current data.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele


    "jackal" <wancherng@msn.com> wrote in message
    news:3e744cf3$1@tnews.web.devx.com...
    >
    > I am a beginner(a student as well) to database programming.
    > I am doing an automatically updated database which imports data from an

    excel
    > spreadsheet. The excel spreadsheet is doing a web query and the data

    inside
    > is changing every minute in real time. I would like to ask how can I

    update
    > my access database automatically every minute by appending new

    records??(using
    > macros? or write vba procedures? how?)
    > (I am able to run the macro manually but I would like to make it run

    automatically
    > after certain interval.) due to there is interior setting in access that
    > perform such a execution.
    > I hope your all can help me.
    > Any suggestions ang ideas are highly appreciated.
    > Thanks




  3. #3
    jackal Guest

    Re: access database: automatic update??


    Thanks to Doug Steele, I have try your way. But it can't help me. Because
    i need the refreshed data in excel to be appended to my existing record in
    access every minute.



    "Douglas J. Steele" <djsteele@canada.com> wrote:
    >Why bother? You can simply link Access to the spreadsheet (as opposed to
    >importing the spreadsheet into an Access table), and it'll always use the
    >most current data.
    >
    >--
    >Doug Steele, Microsoft Access MVP
    >http://I.Am/DougSteele
    >
    >
    >"jackal" <wancherng@msn.com> wrote in message
    >news:3e744cf3$1@tnews.web.devx.com...
    >>
    >> I am a beginner(a student as well) to database programming.
    >> I am doing an automatically updated database which imports data from an

    >excel
    >> spreadsheet. The excel spreadsheet is doing a web query and the data

    >inside
    >> is changing every minute in real time. I would like to ask how can I

    >update
    >> my access database automatically every minute by appending new

    >records??(using
    >> macros? or write vba procedures? how?)
    >> (I am able to run the macro manually but I would like to make it run

    >automatically
    >> after certain interval.) due to there is interior setting in access that
    >> perform such a execution.
    >> I hope your all can help me.
    >> Any suggestions ang ideas are highly appreciated.
    >> Thanks

    >
    >



  4. #4
    Douglas J. Steele Guest

    Re: access database: automatic update??

    I don't understand. When you link, you're pointing to the Excel spreadsheet,
    not making a copy of what was in the spreadsheet at a particular point in
    time. In other words, a linked Excel spreadsheet should show, at any point
    in time, all of the data in the spreadsheet.

    If you've got a form that's displaying the data, you may have to run a
    Me.Refresh on a regular basis, to ensure that recent changes are reflected
    in the form.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele


    "jackal" <wancherng@msn.com> wrote in message
    news:3e7480ed$1@tnews.web.devx.com...
    >
    > Thanks to Doug Steele, I have try your way. But it can't help me. Because
    > i need the refreshed data in excel to be appended to my existing record in
    > access every minute.
    >
    >
    >
    > "Douglas J. Steele" <djsteele@canada.com> wrote:
    > >Why bother? You can simply link Access to the spreadsheet (as opposed to
    > >importing the spreadsheet into an Access table), and it'll always use the
    > >most current data.
    > >
    > >--
    > >Doug Steele, Microsoft Access MVP
    > >http://I.Am/DougSteele
    > >
    > >
    > >"jackal" <wancherng@msn.com> wrote in message
    > >news:3e744cf3$1@tnews.web.devx.com...
    > >>
    > >> I am a beginner(a student as well) to database programming.
    > >> I am doing an automatically updated database which imports data from an

    > >excel
    > >> spreadsheet. The excel spreadsheet is doing a web query and the data

    > >inside
    > >> is changing every minute in real time. I would like to ask how can I

    > >update
    > >> my access database automatically every minute by appending new

    > >records??(using
    > >> macros? or write vba procedures? how?)
    > >> (I am able to run the macro manually but I would like to make it run

    > >automatically
    > >> after certain interval.) due to there is interior setting in access

    that
    > >> perform such a execution.
    > >> I hope your all can help me.
    > >> Any suggestions ang ideas are highly appreciated.
    > >> Thanks

    > >
    > >

    >




  5. #5
    Joe Guest

    Re: access database: automatic update??


    Mr. Steele is correct in that it will automatically update in real time.
    However, if you really want an alternative, each Access Form has a Timer
    Interval property and an On Timer Event. You can place the code in the Forms
    Timer event and set the Timer Interval property to fire at the duration you
    require. Hope this helps.

    Joe




    "Douglas J. Steele" <djsteele@canada.com> wrote:
    >I don't understand. When you link, you're pointing to the Excel spreadsheet,
    >not making a copy of what was in the spreadsheet at a particular point in
    >time. In other words, a linked Excel spreadsheet should show, at any point
    >in time, all of the data in the spreadsheet.
    >
    >If you've got a form that's displaying the data, you may have to run a
    >Me.Refresh on a regular basis, to ensure that recent changes are reflected
    >in the form.
    >
    >--
    >Doug Steele, Microsoft Access MVP
    >http://I.Am/DougSteele
    >
    >
    >"jackal" <wancherng@msn.com> wrote in message
    >news:3e7480ed$1@tnews.web.devx.com...
    >>
    >> Thanks to Doug Steele, I have try your way. But it can't help me. Because
    >> i need the refreshed data in excel to be appended to my existing record

    in
    >> access every minute.
    >>
    >>
    >>
    >> "Douglas J. Steele" <djsteele@canada.com> wrote:
    >> >Why bother? You can simply link Access to the spreadsheet (as opposed

    to
    >> >importing the spreadsheet into an Access table), and it'll always use

    the
    >> >most current data.
    >> >
    >> >--
    >> >Doug Steele, Microsoft Access MVP
    >> >http://I.Am/DougSteele
    >> >
    >> >
    >> >"jackal" <wancherng@msn.com> wrote in message
    >> >news:3e744cf3$1@tnews.web.devx.com...
    >> >>
    >> >> I am a beginner(a student as well) to database programming.
    >> >> I am doing an automatically updated database which imports data from

    an
    >> >excel
    >> >> spreadsheet. The excel spreadsheet is doing a web query and the data
    >> >inside
    >> >> is changing every minute in real time. I would like to ask how can

    I
    >> >update
    >> >> my access database automatically every minute by appending new
    >> >records??(using
    >> >> macros? or write vba procedures? how?)
    >> >> (I am able to run the macro manually but I would like to make it run
    >> >automatically
    >> >> after certain interval.) due to there is interior setting in access

    >that
    >> >> perform such a execution.
    >> >> I hope your all can help me.
    >> >> Any suggestions ang ideas are highly appreciated.
    >> >> Thanks
    >> >
    >> >

    >>

    >
    >



  6. #6
    lakshman Guest

    Re: access database: automatic update??


    "jackal" <wancherng@msn.com> wrote:
    >
    >I am a beginner(a student as well) to database programming.
    >I am doing an automatically updated database which imports data from an

    excel
    >spreadsheet. The excel spreadsheet is doing a web query and the data inside
    >is changing every minute in real time. I would like to ask how can I update
    >my access database automatically every minute by appending new records??(using
    >macros? or write vba procedures? how?)
    >(I am able to run the macro manually but I would like to make it run automatically
    >after certain interval.) due to there is interior setting in access that
    >perform such a execution.
    >I hope your all can help me.
    >Any suggestions ang ideas are highly appreciated.
    >Thanks



  7. #7
    lakshman Guest

    Re: access database: automatic update??


    "jackal" <wancherng@msn.com> wrote:
    >
    >I am a beginner(a student as well) to database programming.
    >I am doing an automatically updated database which imports data from an

    excel
    >spreadsheet. The excel spreadsheet is doing a web query and the data inside
    >is changing every minute in real time. I would like to ask how can I update
    >my access database automatically every minute by appending new records??(using
    >macros? or write vba procedures? how?)
    >(I am able to run the macro manually but I would like to make it run automatically
    >after certain interval.) due to there is interior setting in access that
    >perform such a execution.
    >I hope your all can help me.
    >Any suggestions ang ideas are highly appreciated.
    >Thanks



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center