Importing updates from an online source

[Dave C]

I have an application that I have distributed to users who have downloaded it
my web site. The database contains several tables that are time-sensitive,
and need to be updated with new prices a few times each year.

Is there a way to import data from an online file? When started, I want the
application to check my web site for a new file, then prompt the user with
the option to import the new prices.

Note that I'm not looking for an online shared database, just a way to
update the local tables on the user's computer.

Thanks

 

[Dave C]

I just tried...

docmd.runsql "INSERT INTO tblTest SELECT * FROM tblTest IN
'http://www.mywebsite.com/Test.mdb'"

.... on the off chance it would work. Unfortunately, I got an Invalid File
Name error.