Access to php

[Daz69]

I need some help explaining the best approach for the following:

 

I have an access database used within a company that I wish to extract data from and publish on a web site, easy enough? What is the 'usual' method exporting the data (probably twice a day) to the website?

 

I thought xml would be ideal as I could schedule the export/ftp of the data up to the site, but xml manipulation in php doesnt seem straightforward (php newbie) - maybe csv?

 

I've got php with mysql working fine but is there any automated process to get from local Access to online based mysql?

 

What does everyone else do?

 

Thanks -- Darren

[Mchl]

You can connect directly from PHP to Access through ODBC

[Daz69]

Thanks for the reply

 

but my access database isnt online, I guess I can schedule a query to update a second database containing only a table of required data that is then uploaded, but it doesnt seem that elegant.

[Mchl]

Well.. you need some way to connect to access if you want to fetch data from it. I'm using a secondary access databse that only has linked tables to the "real database" across the network. Works most of the time

[Daz69]

The more I think about it the more using a secondary dbase seems like the best idea.

 

In your case, what dbase actually sits on the web server?

[Mchl]

Only the 'secondary' one that links to 'real' one through intranet.

Added benefit is, that you can actually change table names in 'secondary' database, so that you can get rid of MSAccess names.