There's only two ways I know of to do this. 1.) You have
to create a link to the EXCEL sheet in question using MS
SQL Enterprise Manager. Then create a scheduled job to
run an SQL statement to update the SQL table. Note:
Changes to the EXCEL file will update automatically
through SQL link. 2.) Create an Access DB with links to
the respective tables and worksheets. Create a PASS
THROUGH query that updates the SQL table using the EXCEL
data. You will then need to create a MODULE that runs the
query every 10 seconds.
In both cases, in order to keep them running every 10
seconds you have to have all the respective programs open
at all times.
I do not know what you level of expertise is. All of what
I said may have gone over you head - or maybe not.
However if I was vague it's because if I were to write it
all out on a novice level it would be as long as a chapter
in a book. The really frustrating thing is I could talk
you through it over the phone in less than 10 minutes. If
you would like me to expound on how to do this, please
reply to me personally and I'll be happy to write out the
entire procedure.
Marty
