您如何将数据从excel电子表格导入ORACLE APEX? [英] How do you import data from your excel spreadsheet to ORACLE APEX?

问题描述

我对数据库是完全陌生的，我想知道是否存在将excel文件中的数据直接上传到ORACLE APEX的方法，如果不是，最好的方法是上传15MB左右的小型数据集.CSV扩展名. /p>

I am completely new to databases, was wondering if there were ways to direcly upload the data in an excel file, to ORACLE APEX, if not, what would the best way be to upload small datasets .CSV extension around 15MB.

推荐答案

Apex使您可以使用数据加载向导"直接上载CSV文件.您可以找到很多教程. 此处是只是一个.

Apex enables you to directly upload CSV files using the Data Load Wizard. You can find a lot of tutorials. Here is just one.

您还可以使用以下方法上传Excel文件:

You can also upload Excel files using the following methods:

• EXCEL2COLLECTIONS插件
• 创建一个将excel数据转换为字符串的过程. 此处的教程.
• 使用AS_READ_XLSX软件包. 此处的教程.

• EXCEL2COLLECTIONS Plugin
• Create a procedure that will translate excel data into strings. Tutorial here.
• Using AS_READ_XLSX package. Tutorial here.

不要害羞地使用Google，因为您会发现更多选择.

Don't be shy to use google because you will find many more options.

这篇关于您如何将数据从excel电子表格导入ORACLE APEX?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！