Now I don’t believe this is practical or possible without a large amount of development. My client’s old site used MS Access to manage the user’s profiles on his old website.
His new site uses BuddyPress to manage user profiles, his old site was a bespoke WordPress members system.
I’m just trying to get a concrete answer from someone who knows – is it practical or possible to manage users from MS Access or is it more hassle then it’s worth.
Cheers!
If you know something about databases, and have access to the back end SQL database (most likely through Cpanel/phpMyAdmin, you can see the structure of the database, including the columns (fields) and their attributes. Knowing this, you can export an Access query into an Excel file with the same fields and attributes as the BuddyPress SQL table, save the Excel file as a csv file, then import the csv file through phpMyAdmin’s import function.
I’ve done this several times. I don’t use BuddyPress, so I don’t have the table structure, but you can design all your query exports to Excel to match the SQL structure of the tables in question.