As the title suggests, I need to import data from a file to tables that have many-to-many relationships like in the example posted here : Many to Many
there is one main table (tblProviders), which has a linking table (tblProvServ) which links providers with services (tblServices). This structure is repeated once more, but all I really need to know is how to import data so that the linking table gets the right "service to provider" record (since both services and providers are indexed, and the joining table has 2 fields, one for each index). Assuming now, that the file to be imported is an excel file.
ALSO-- is it wise to use autonumbering as the Provider index field's data type? initially I liked the idea out of laziness, but it looks like there might be problems with importing... advice?
Thanks
there is one main table (tblProviders), which has a linking table (tblProvServ) which links providers with services (tblServices). This structure is repeated once more, but all I really need to know is how to import data so that the linking table gets the right "service to provider" record (since both services and providers are indexed, and the joining table has 2 fields, one for each index). Assuming now, that the file to be imported is an excel file.
ALSO-- is it wise to use autonumbering as the Provider index field's data type? initially I liked the idea out of laziness, but it looks like there might be problems with importing... advice?
Thanks
