Moving text from Excel to Oracle


#1

Hi,

I can’t work out how to select text on an Excel document, and then paste it into a specified field in Oracle.

If anyone can enlighten me, I’d be very grateful.

Regards,

Vennie


#2

Hi @Vennie,

Kindly check the example attached. I hope it helps.

Main.xaml (11.5 KB)


#3

Hi,

Thank you for your reply.

Can I ask though, in the “Body” “Assign” box it says “Get information from column name” then there are two fields underneath "Name = row.item(“Name”). What do I need to put in here, is it the Excel cell?

Thanks again for your help.

Vennie


#4

Hi @Vennie,

I didn’t get your doubt, but it will iterate between every record in the excel file because it is now in a datatable located in the computer’s memory.

Please test it and try to understand it.