I have taken over development of a database used for creating mailing labels and other info. Currently the structure is that each type of label (eg Friends, Employees, Customers etc) is in a seperate table. Each table contains peoples names and addresses etc.
I have created a new table with 3 main tables: Contacts, Addresses and Mailing list
Does anyone have any idea how to take the current flatfile structure and convert it into the new format??
