A client of ours has a number of small databases, all of which have one table, a small number of scripts, and are pretty rudimentary. They want these databases combined into one file for hosting purposes. Down the road they will have a proper relational system built, but in the short term they are just wanting a single consolidated file.

The process of combing all of these files into a single file is pretty easy, even if a bit repetitive and mildly time consuming. The largest issue is moving value lists. They are all simple text type (non related) lists but there are lots of them and I can find no way to move them easily from file to file.

Anyone have any suggestions? Is there a handy tool that anyone is aware of?

Thanks in advance.

Yes, change all the value lists to be based on tables, rather than hard-coded, when you get around to rewriting their system.

No, there are no tools, afaik, for import/export of hard-coded value lists.