Skip to main content

is it possible use select * from 'excel file' then insert into 'table' by plsql script?

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