Is Drupal compatible with Microsoft Access?

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
vstarsal's picture
Posted by vstarsal on June 14, 2012 at 1:54pm

I am new to Drupal and have managed to create the basic website that my client wants, but they have a MS Access database. I cannot find any information anywhere that even mentions Access in relation to Drupal. Is it possible to have forms (I have created in html) be populated with data from this Access database through msqli queries in php? Any help is greatly appreciated.

Categories:

Comments

To my knowledge, Drupal is

Posted by wfx on June 14, 2012 at 2:10pm
wfx's picture

To my knowledge, Drupal is not compatible with Access. I've found http://www.kitebird.com/articles/access-migrate.html which shows how to convert Access to MySQL.

http://www.webbfx.net/

iMacros can fill in forms

Posted by jasonsamuels on June 14, 2012 at 2:51pm
jasonsamuels's picture

I used this during our website migration to fill in forms based on rows in a CSV file - http://www.iopus.com/imacros/

It's not perfect, but takes a lot less technical know how than under-the-hood scripting. Pro tip if you use it - a single special character in your CSV file will cause the job to fail. Run find-and-replace operations on common ones, and if still having problems take it a handful of rows at a time until finding the culprit.

Thanks wfx and jasonsamuels.

Posted by vstarsal on June 14, 2012 at 10:50pm
vstarsal's picture

Thanks wfx and jasonsamuels. I kind of thought that Access wouldn't work with Drupal, but this is the first that I have heard one way or the other. I will see if I can get the client to switch over to mySQL instead.