[gregbatch]

I did the merge file setup in Excel. Let me look and see if I still have it handy and I'll get back to you.

Basically I did this:
1. Did export in MySQL Admin to get the structure.
2. rearranged columns in Excel to match the db structure
3. Exported from Excel as tab separated (can't use commas, as they may be in text and Excel doesn't put the " qualifier on it.
4. Opened in Word Perfect and did search for tab and replaced with |
5. Imported data in MySQL Admin using | as my separator

It seems like alot, but in reality it takes only a few minutes compared to entering it. Now, I know there are some great data utilities out there that will rearrange, parse, merge, and change delimiters on various text files, but I needed something fairly quick and didn't have time to look.

I'll keep looking for those file for you...