By jimlyke on

I am in the process of converting an ugly Microsoft website with static pages mixed with ad hoc ASP / Javascript into a Drupal site for a figure skating club. THere is this access database with several hundred members and test scores. I guess I could set up CCK to have the right fields for the score, but is there a way to easily suck in the database into drupal? I could export Access in CSV, XLS, etc if that helped. Same question for the members. One more thing is how could I link scores to a member with a pull-down or something? Sorry to ask so many questions in a single post.

⋅ Categories: Drupal 6.x

Comments

missym’s picture

missym commented

You can try the node import module. I just set up my tables then used my phpMyAdmin to import into the tables I'd set up. Then I updated the sequences module. I prep the file a bit by creating my keys (node id) and link ids for parent/child relationships.

Good luck!