export record to .php and send to MySQL via hidden browser (1 Viewer)

[memaxt]

Hi there,

I am unable to link MySQL database to my local Access Database due to having a Dynamic IP (not the best of providers we chose)...anyway I had a thought!

Is it possible to export a new appended record to a .php file which then sends data to MySQL via a hidden browser?

sounds very long winded but I cant keep importing data tables directly in MySQL.

Many thanks
Max

 

[John.Woody]

Can you connect a local access db to your MySQL db? It can be. Done using ODBC driver, but your MySQL host may block the connection with their firewall. If you can then you could append data from access directly into MySQL.