Menu
Community /Pin to ProfileBookmark
@NogDogJan 14.2022 — #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). @NogDogJan 15.2022 — #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](https://medium.com/an-idea/import-csv-file-data-into-mysql-table-with-phpmyadmin-96024fc11f5d) (not claiming it's the best article, just the first I came up with...I use PostgreSQL these days.)
How to incorporate MS Access database into WordPress site
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…
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJan 14.2022 — #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).
0
@NogDogJan 15.2022 — #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: