Thanks for the question, Abdurasak.
Asked: November 06, 2023 - 2:43 pm UTC
Last updated: November 07, 2023 - 5:07 am UTC
Version: 1
Viewed 1000+ times
You Asked
Question:
I am building a freelancing local website with Oracle Apex. I have all of my data in Excel spreadsheets, but I am not sure how to import them into Apex. I have multiple spreadsheets, one for each table in my database (e.g., users, freelancers, clients, jobs, proposals, contracts, etc.). The spreadsheets also contain foreign key relationships between the tables.
What is the best way to import these spreadsheets into Apex? Is there a way to automatically create the tables and relationships from the Excel sheets? Are there any best practices or common pitfalls to be aware of when doing this?
you can check my application sample tables here: [redacted]
Thank you for your help.
Sincerely,
and Connor said...
A quick and easy way would be to take each sheet and do "Create New Application from Excel" with each one. It will create the tables, load the data, plus guide you through datatype selection etc.
That will give you a table/keys for each one, plus a simple reporting/maintenance app on each table (just in case you need that later).
We're not going to handle relationships *between* the tables, but once you've imported each sheet, you can define those in the SQL Workshop.
Is this answer out of date? If it is, please let us know via a Comment