Reading Access tables then Writing to SQL tables

[alienation]

Hi! I want my program to run an infinite loop that reads new data every 5 mins from an Access 97 table, then append it to an SQL Server 2005. I'm still using VB6.

This loop should start automatically in the background when the VB program is started.

I was thinking of putting the code on the Form Load part of the program. Any thoughts on how to code this?

[RhinoBull]

Welcome to Forums!

If you need to this on a timely basis then you can do either:

- run your program from the windows task manager every so often and execute some code on form_load (as you said) or from the sub main
- or using timer and having your app running all the time

For ado tutorials and sample code visit our dartabase forum - there is a sticky thread.