Dear all,
Now I have an empty table called "Inquiry Result", I want to load the data through spreadsheet(excel). But in App Studio I can't find such feature for me:
Also when I go into the Load Data module, I can't find my table
So I am confused, where can I load data for my table by uploading excel?
Hi @Junyu,
This is the process of importing data to an existing table.
Open the app in App Engine Studio, In the Data section click on 'Add'.
The select Import and map data -- get started -- Name the import and provide the description like below and click continue.
After this you will taken to the below page where you need to select source type and upload the excel
After that in the Map to target, you need to mention the table(existing) where the data needs to be imported.
After the you can either execute the schedule now or you can execute it at any specific time as well.
Please mark this answer as correct and helpful if it solves your issue.
Regards,
Siva Jyothi M.
Hello @Junyu , try this method,
Open the app in App Engine Studio, In the Data section click on Add
Select Create a data integration option and select Continue
Enter Name and Short description and click on Continue
This will create data import in your app
select source type as a file and select Excel then upload an excel file from your PC, select configuration (Sheet name and row header) and click on save
Select Map to target from setup steps
Select your target table, and choose checkboxes according to your requirement and click on Save
Click on mapping table
Mapp fields according to your requirements and click on save button
Click on Schedule imports from setup steps and click on Run Import (if you want you can create a schedule here)
Data import is successful now
Hope it will work, please mark my answer as helpful, if it works.
Thank you
