• Is there anyway to link MS Access to our online directory so that when we update Access it automatically updates info in the directory on our website? Or at least an easier way maybe importing a .csv file? We are planning to update our website soon with a new theme – paid Elementor page builder. We’re hoping to include a map of where the churches are located with the addresses popping up when hovering. Currently we manually update addresses and personal info in about 4 or 5 different places (including this webpage) and if there’s an easier way to do it, I’d like to learn how! 🙂

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • No, unfortunately WordPress’ database is SQL/PHP driven.

    Moderator bcworkz

    (@bcworkz)

    The short answer is essentially no for the reasons stated. It is conceivable to make use of a common format like CSV. You could upload the exported .csv file to your WP server and develop a custom WP page template that reads the file data and outputs a nicely formatted webpage. It’s not very efficient to do so on every request, so some sort of caching scheme would be a good idea.

    Getting that same CSV data to work on a map also would involve custom coding to parse the file data into something the mapping app can understand. Since the template code is PHP based and the mapping app is likely JS based, you’re looking at two different development projects that more or less do the same thing. Ideally, the other locations where changes are made would all work off the same file, which probably means even more custom coding. And you still need to manually export the .csv file and upload anytime there is a change.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Importing directly from MS Access Database to WP directory’ is closed to new replies.