I need to create a bunch of pages for my WP site. What I would like to do is have a page for each state in the U.S., followed by many sub-pages corresponding to all the cities in that state. For example:
All this data is maintained in text files. Anyone have any ideas on the best approach? Some thoughts I had were to create some mySQL tables and populate them with the text files, then insert pages thru SQL inside of the wp_posts table.
Another approach was to just upload the directory structure I need thru FTP then somehow link that back to my site.
Thanks for any help with this!