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 asked 07 Sep '22, 11:56 gchq |
I would create an "Import" table to upload the given Excel file without limitations. Then you could:
Afterwards you can remove this "Import" table. You could also leave it in the database for future imports of the same Excel format. answered 08 Sep '22, 03:59 Frank Vestjens |