Hello Richard.  Is there any quick way to normalize a flat file with large amounts of data?  I am looking to split my flat file database into 8 tables, each with one-to-many relationships.  If I just use what we have learned so far, I'm afraid it'll take much too long converting everything manually. I tried letting Access' wizard do it when I imported from Excel, but it totally butchered my data!  
Thanks in advance.

---

Reply from Richard Rost:

Shaun, in Access Expert 22 I cover some techniques for fixing flat-file data that you've imported from another source.