How to incorporate MS Access database into Wordpress site

saranee

I am setting up a Wordpress website for a new client. They have a large membership (10,000 members?) and would like to incorporate their member database which is currently on MS access into the website. I have never worked with MS access. Is this possible and if so, how would you do this? Any suggestions?

Thanks...

sibert

saranee f so, how would you do this? Any suggestions?

First of all I should reconsider Access as a database. According to Wikipedia it is a datafile based solution, which Microsoft recommends max 20 concurrent users. It sure can be used together with a website with several limitations IMHO.

I should consider a SQL or noSQL database (depending on data structure) that is more suitable. And you can use Linux as the host of the website (Access cannot run on Linux). Windows hosting Wordpress I doubt will be a good choice.

My choices should be WP on Linux and MySQL (or Postgresql) as database.

NogDog

Depends on what you mean by working with Access. If you simply(?) want to import data from it into your site's database, then you're probably looking at exporting the Access data of interest into a CSV file, then using some SQL or your database admin tool to import that file's data into your database (or creating a script to do so, etc.).

If you want to interact directly directly with Access from your site, I don't think PHP comes with any built-in support for it, so that would likely be a non-trivial challenge (or worse).

saranee

The club has an extensive membership list currently on an MS access database. They are redesigning their website and making it more current. The current site is quite old. They would like to have a password protected page that their members can go to to find phone numbers or emails of other current members. I'm just wondering how I might accomplish this without have to retype 1000 members into a new database :-). If I export the data into a CVS file, what then would I do to incorporate that file into the website?

NogDog

If you use a tool such as PHPMyAdmin to manage your database, it probably has built-in tools for importing from CSV. E.g.: first article I found: Import CSV file data into MySQL table with phpMyAdmin (not claiming it's the best article, just the first I came up with...I use PostgreSQL these days.)