Breaking Up table in FK and PK

[drunkenneo]

I have a situation where i need to import a table in Access which is in Excel, After importing i need to know how can i break it up differently keeping relation of FK and PK intact: For Eg


Excel Sheet:

Name Biz ID Biz Name Address1 Address 2 Address 3 OrderNo Order Date


Person Record
ID(PK) Name Biz ID Biz Name Address 1 ....

Order Record
OrdIDPK ID FK OrderNo Order Date

How can i distribute it?

[June7]

Could use BizID as the PK/FK.

[orange]

cross posted http://www.access-programmers.co.uk/....php?p=1312463

When you cross post, please advise the readers that you have done so.

[drunkenneo]

My main challenge is to separate the table content to different tqbles keeping the relation ship intact

[drunkenneo]

Could use BizID as the PK/FK.

It gave a thought, i will do it, but main challenge is pretty different, to separate the content of the table with reference remain intact

[June7]

Actually, by using the BizID as PK/FK, it can be easy, assuming there are no errors in spelling of business names and the address info is exactly the same for all instances of the same business. However, those are dangerous assumptions. Any variance will complicate.

Make a copy of the table, rename it Orders, delete the BizName and Address fields.

Do a query that will select unique BizID, BizName, Address1, Address2, Address3 records and create a new table called Persons.

The original table can be eliminated.

Additional steps will be required if you want to make an autonumber field the PK/FK.


Or create a link to the Excel worksheet and run the Analyze Table utility. http://support.microsoft.com/kb/292799

[drunkenneo]

Thanks June it was a help