is it possible use select * from 'excel file' then insert into 'table' by plsql script?
Userlevel 7
I don’t know of a way, but you can use “CREATE_TABLE_FROM_FILE” to insert the data from Excel into a table.
There is no support to load data directly from excel
You can use the IFS Migration tool(s) for loading data into the system:
- Data Migration Manager -> Load Legacy Data
- Foundation Migration Tool -> Method Type CREATE_TABLE_FROM_FILE
Both requiring flat files (csv or txt)
Depending on why you want to load data it could be also an option to use our projections and call them via Postman or other tool to load data.
If it's more related to a kind of interface maybe using Boomi is the right choice. So there are different approaches depending on what you want to achieve
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.