flat file to relational - possible?

[recon0302]

I have a db I made for work. It is a flat file db that users can enter records. On this flat file db are several fileds that are used to put names, addresses, phone numbers, etc. I built the table using name1, name2, etc, address1, address2, etc. There are five of these. I built this db a while back and there are over one thousand records in it now. I have built a new relational db that uses many of the same fileds. I now have one form for name, adress, phone, etc. How can I import the fields into this new db from the name1, name2, etc without replacing the table? Is is possible to just add the data from these other fields. How do I marry them? I'm losing time fast so any help would be greatly appreciated.

Marty

 

[argeedblu]

One approach would be to create a link in your new database to the table in the old one. Then create a series of append queries that would select the information from the original table to the relevant tables in your new database.