Import .mdb data into Drupal
Hi to all,
i have to import a touristic accomodation database in .mdb format (microsoft access) into Drupal 6. I'd like to share ideas on how to accomplish this task.
Here is my initial workflow to import the records and make them searchable:
1)Create a custom CCK with all the needed fields
2)Convert the .mdb database into .csv (comma separated values) file
3)Use node_import module to import the csv
4)create a view
5)expose the view filters to made the imported records searchable throught a form
Are these steps correct or there are smarter options?( the database have a lot of fields to enter manually as cck fields...)
Note: i have already imported successfully a data/calendar like database with node_import + Node Import Translation Support approach
Thanks for answering
Danny
