Forum Stats

  • 3,838,322 Users
  • 2,262,353 Discussions
  • 7,900,584 Comments

Discussions

Update table wizard (Excel)

clackerz
clackerz Member Posts: 5
edited Oct 10, 2018 8:19AM in SQL Developer

If this question has been raised before, apologies, I did try to search but could find what I was looking for.

I'm a new user of SQL Developer, and have a question around updating a table using an excel spreadsheet.

I've come across from using Toad which has an Add/Append or Update options as part of the import wizard

It's an extremely useful tool/option when mass updating data into a table.

The process matches primary keys and will update matched records on the columns provided.

I cannot find a same/similar options / process for SQL Developer

Is there such a thing?

If not how do I go about completing a mass update of records via an Excel spreadhseet?

Thanks everyone

clackerz

Answers