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

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

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
>
>

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
> >
> >
>

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
>> >
>> >
>>
>
>

"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

"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