Import data from xlsx, but not duplicates

I have used SQL Central a number of times to import data, but now want to edit an Excel spreadsheet and import data that excludes some existing records. No doubt there will be a unique record (like website address or phone number) but I'm not sure of the best way to import limited records.

Thank you

sa-17

asked 07 Sep '22, 11:56

gchq
321●26●29●36
accept rate: 33%

flat view

One Answer:

active answers oldest answers newest answers popular answers

I would create an "Import" table to upload the given Excel file without limitations.

Then you could:

Use SQL statements to import the correct data from this "Import" with the proper excluded data.
Remove/update the data in the "Import" table that should be excluded before importing the data from this "Import" table

Afterwards you can remove this "Import" table. You could also leave it in the database for future imports of the same Excel format.

permanent link

answered 08 Sep '22, 03:59

Frank Vestjens
1.1k●31●41●56
accept rate: 23%

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-17 ×222

question asked: 07 Sep '22, 11:56

question was seen: 360 times

last updated: 08 Sep '22, 03:59

SAP SQL Anywhere

Import data from xlsx, but not duplicates

Follow this question

Related questions