Posted by vstarsal on June 14, 2012 at 1:45pm
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.
Comments
I have no experience in
I have no experience in accessing MS Access Databases from forms. But you can export-import data from Access to MySQL trhough ODBC. In my case clients export the MS-A data to the Drupal database using SQL trhough a ODBC conection.
More information:
http://drupal.org/node/228613
data migration from MS Access
It's not clear to me why you want to populate form elements (you should look at the webforms module rather than create HTML forms) but whenever I've looked at data migration issues I frequently turn to the Feeds module. If you can export the MS Access database as csv or xml you can use Feeds and a CSV or XPathParser importer to bring the data into the Drupal content module (as CCK nodes) then populate form elements (built automatically when the CCK nodes are created) from the local data. Do a google search on "drupal feeds csv import" and you'll find a lot of examples including some good video tutorials.