Hi there
I have an excel spreadsheet which I would like to transfer to access. Each row of the spreadsheet represents an enquiry/purchase to a particular item.
I've imported it (after sorting out all the column data) and it works ok..
However, I have duplicate information relating to orders (where one purchaser has maybe asked about a few items)
I really need to seperate the columns into different tables..
ie 1 customer table
1 item table
1 billing information table
1 results table
But each table would need to use data from one of the other tables...
for example I would need to have the customer details and item details for the billing table..
Obviously I wouldn't want to have 2 customer records if they were a frequent user...
What would be the best way to handle this..and how would I do it...(I'm more used to excel than access)
Cheers
DUCKERS..
I have an excel spreadsheet which I would like to transfer to access. Each row of the spreadsheet represents an enquiry/purchase to a particular item.
I've imported it (after sorting out all the column data) and it works ok..
However, I have duplicate information relating to orders (where one purchaser has maybe asked about a few items)
I really need to seperate the columns into different tables..
ie 1 customer table
1 item table
1 billing information table
1 results table
But each table would need to use data from one of the other tables...
for example I would need to have the customer details and item details for the billing table..
Obviously I wouldn't want to have 2 customer records if they were a frequent user...
What would be the best way to handle this..and how would I do it...(I'm more used to excel than access)
Cheers
DUCKERS..