Excel - convert to SQL with relation ID
3786
£25(approx. $31)
- Posted:
- Proposals: 2
- Remote
- #370912
- Archived
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I'm in the process of creating an ordering system and I have a Excel spread sheet with the catalogue comprising of 4 worksheets, I need it converting to MySQL with each table relating to the relevant worksheet ID.
IE Model > Franchise or Model Type > Model so it becomes a relation database using id's and fk rather than working on text as the relationship.
The 4 tables are as follows:
Franchise
Model (Model > Franchise)
Model type (Model Type > Model)
Item Catalogue (Item Catalogue > Model Type)
IE Model > Franchise or Model Type > Model so it becomes a relation database using id's and fk rather than working on text as the relationship.
The 4 tables are as follows:
Franchise
Model (Model > Franchise)
Model type (Model Type > Model)
Item Catalogue (Item Catalogue > Model Type)
Whales Have Accents
100% (19)Projects Completed
23
Freelancers worked with
22
Projects awarded
20%
Last project
15 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies