Skip to main content
Question

select * from 'excel file' then insert into 'table' by plsql


Forum|alt.badge.img+6
  • Sidekick (Customer)

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

  • Superhero (Employee)
  • March 22, 2023

I don’t know of a way, but you can use “CREATE_TABLE_FROM_FILE” to insert the data from Excel into a table. 


Forum|alt.badge.img+10
  • Hero (Employee)
  • March 30, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings