Posted by stephanieshea on February 25, 2010 at 11:31pm
Does anyone have any insight into how we might convert our access database which resides on one staff members computer - containing orders; processes reports etc for acquisitions in our public library system?
Comments
Node Import
Not sure what needs to be done on the Access side of things, but the Node Import module (http://drupal.org/project/node_import) does a bang-up job of creating Drupal nodes from a CSV file. Be sure to read this issues thread about making imports into content types with Date fields work: http://drupal.org/node/374346
There might be complications if you're importing separate data files into different content types that need to connect via a nodereference field. I've never tried to do that.
Or a possible non-Drupal approach: Maybe upload the Access db (I think you might need to export into Excel first) to Google Docs and use that?
I suspect there are additional options you could consider, too.