Best way to convert Flat File to Relational dB ??

[Will]

I have a Single Table database with lots of fields and duplicate data...
(Basic contact information was entered over and over in each record.)

I created a Contacts Info Table with one record per contac and an IDcontacts
Key field.

I want to remove the duplicate data fields from the main table and put in
the IDcontacts and relate it to the Contacts Info Table.

I guess the problem is how to get the correct IDcontacts data inserted into
each record of the main table.

Can anyone give me some help on the best way to do this job.

thanks for the help.

Will

 

[SusanV]

Hi Will,
After creating the new contacts table use an update query to copy the data
from the main table to the contacts table. After you check that the data has
been successfully brought into the new table and that any forms and reports
are pointing to the correct table for those fields, you can simply delete
the no-longer-needed fields and compact the database.

 

[fredg]

I have a Single Table database with lots of fields and duplicate data...
(Basic contact information was entered over and over in each record.)

I created a Contacts Info Table with one record per contac and an IDcontacts
Key field.

I want to remove the duplicate data fields from the main table and put in
the IDcontacts and relate it to the Contacts Info Table.

I guess the problem is how to get the correct IDcontacts data inserted into
each record of the main table.

Can anyone give me some help on the best way to do this job.

thanks for the help.

Will

After you import your flat Database data, click on Tools + Analyze +
Table.
Let Access do the work.