=?Utf-8?B?RGFuaWVsIFBpbmVhdWx0?=
wrote in
:

He is very right that it is possible to remotely, using odbc,
connect to a web db. That said, before counting on this approach,
you need to verify with your host if they allow such remote
connections. Many do not for security reasons. In which case you
would need to look into alternate approaches.

One alternate approach (which I use all the time) is to install a
local installation of MySQL and phpMyAdmin. If you create a DSN for
your MySQL database (even if it has not tables in it), you can then
export your Access tables to that DSN (ODBC is one of the export
options). Once you've got the local MySQL, you can then use
phpMyAdmin EXPORT to write a script that you can then upload to your
server and run there. Most ISPs provide phpMyAdmin as the interface
for MySQL, so it's pretty easy to do. If they don't, you can
probably install it yourself (it's not that difficult).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/