Automatically appending to a Table

[Peter Bellamy]

I have a table which is is a linked area of a spreadsheet
New lines are being added to this SS on an ad hoc basis.

I want to use the data in these lines in my database so I have another Table to contain them, and an append query adds them, as and when.

Is there a way of running a background process that looks for a new line and then adds it to the Table, instead of the manual process I have at the moment?

Cheers
Peter

 

[namliam]

How about a simple one??
Simply do an append query anytime the database is opened??

This way its always up to date, the append shouldnt take long..

 

[Peter Bellamy]

Unfortunately the SS is updating whilst the Db is open. It is recording a manufacturing process !

 

[namliam]

Perhaps have a timed (hidden) form update every minute or every 5 minutes?

 

[Peter Bellamy]

That's a nice idea !
I will try it.

Thanks